Snowflake Solutions Expertise and
Community Trusted By

Enter Your Email Address Here To Join Our Snowflake Solutions Community For Free

Snowflake Solutions Community

How do I connect Teradata SQL Assistant to Snowflake?

6.77K viewsConnecting to Snowflake
0

How do I connect Teradata SQL Assistant to Snowflake?

Alejandro Penzini Answered question May 12, 2023
0

To connect Teradata SQL Assistant to Snowflake, you need to follow these steps:

Install and configure the ODBC driver: Snowflake provides an ODBC driver that you can use to connect to the database from Teradata SQL Assistant. You can download and install the driver from the Snowflake website. Once installed, you need to configure the driver by providing your Snowflake account details.

Create a DSN: After installing and configuring the ODBC driver, you need to create a DSN (Data Source Name) that Teradata SQL Assistant can use to connect to Snowflake. To create a DSN, go to the ODBC Data Source Administrator in your Control Panel and click on the "Add" button. Select the Snowflake ODBC driver and enter your Snowflake account details.

Connect to Snowflake: Open Teradata SQL Assistant and click on the "File" menu, then select "New." In the "Connection" tab, select "ODBC" as the connection type. In the "ODBC Data Source Name" field, select the DSN that you created in step 2. Enter your Snowflake username and password, and click "OK" to connect.

Test the connection: Once you have connected to Snowflake, you can test the connection by running a simple query. For example, you can run the following SQL statement to check the version of Snowflake that you are connected to:

SELECT CURRENT_VERSION();

If the query returns a result, then you have successfully connected Teradata SQL Assistant to Snowflake.

Note that the specific steps for connecting Teradata SQL Assistant to Snowflake may vary depending on your environment and configuration. It is recommended that you consult the Snowflake documentation or seek assistance from their customer support team if you encounter any issues.

Alejandro Penzini Changed status to publish June 30, 2023
You are viewing 1 out of 1 answers, click here to view all answers.

Sign in with google.com

To continue, google.com will share your name, email address, and profile picture with this site.

Harness the Power of Data with ITS Solutions

Innovative Solutions for Comprehensive Data Management

Feedback on Q&A