Importing data from Snowflake

PreviousImporting data from Mongo DB NextImporting data from MySQL

Last updated 1 month ago

Importing data from Snowflake

You can import the datasets from Snowflake to the RapidCanvas platform. For this, you must establish a connection with to Snowflake by providing the account details. After establishing the connection successfully, you can select the warehouse and database from where you want to fetch the datasets.

To import data from Snowflake:

Hover over the menu icon and select Connectors. The Connectors page is displayed showing the total number of connectors.
The Data connectors screen is displayed.
Click the plus icon on the top. You can also use the +New data connector button on the workspace to create a new connection.
Click the Snowflake tile.
Click Create Connection. The Data connectors configuration page is displayed.
Specify this information to configure Snowflake Data connector and access files stored in this Snowflake account:
Name: The name of the Data connector. User: The name of the user account. Account: The name of the account. Choose any of these options Password: Enter the password of the user account Key Authentication: Private key - Provide a private key to enhance security and eliminate the need for passwords. Passphrase (optional) - Provide the passphrase only for encrypted private key. This is used to protect the private key associated with your Snowflake connection. During the initial connection setup, users will be required to enter the passphrase. This passphrase is not transmitted to Snowflake, but it adds an additional layer of security to ensure safe and secure authentication

Click Test to check if you are able to establish the connection to the Data connector successfully.
Click Save to save the database details. The Data tab fields are enabled only after saving the connector details.
Specify this information on the Data tab. The fields on this tab are enabled only after you establish connected with the Data connector.
Warehouse: The warehouse to which you have to connect.
Role: The permission assigned to the user.
Database: The name of the database to use.
Schema: The schema of the file.
Jsonquery: The JSON query you have to provide in the terminal to fetch the data you want.
Click RUN QUERY to run this query and fetch the data from the database.

Once the connection is established, you can see the data imported from the Snowflake to the platform in the table format.

You can manage files, datasets, and published outputs for this data connector across different tabs:

Data Tab: View the files retrieved from this data connector.
Datasets Tab: See the projects where datasets fetched from this data connector have been used.
Schedulers Tab: View the outputs published to this connector. When creating a scheduler, users can configure an external connector as the destination to publish the generated outputs upon job execution.

PreviousImporting data from Mongo DB NextImporting data from MySQL

Last updated 1 month ago

To import data from Snowflake:

Hover over the menu icon and select Connectors. The Connectors page is displayed showing the total number of connectors.
The Data connectors screen is displayed.
Click the plus icon on the top. You can also use the +New data connector button on the workspace to create a new connection.
Click the Snowflake tile.
Click Create Connection. The Data connectors configuration page is displayed.
Specify this information to configure Snowflake Data connector and access files stored in this Snowflake account:
Name: The name of the Data connector. User: The name of the user account. Account: The name of the account. Choose any of these options Password: Enter the password of the user account Key Authentication: Private key - Provide a private key to enhance security and eliminate the need for passwords. Passphrase (optional) - Provide the passphrase only for encrypted private key. This is used to protect the private key associated with your Snowflake connection. During the initial connection setup, users will be required to enter the passphrase. This passphrase is not transmitted to Snowflake, but it adds an additional layer of security to ensure safe and secure authentication

Click Test to check if you are able to establish the connection to the Data connector successfully.
Click Save to save the database details. The Data tab fields are enabled only after saving the connector details.
Specify this information on the Data tab. The fields on this tab are enabled only after you establish connected with the Data connector.
Warehouse: The warehouse to which you have to connect.
Role: The permission assigned to the user.
Database: The name of the database to use.
Schema: The schema of the file.
Jsonquery: The JSON query you have to provide in the terminal to fetch the data you want.
Click RUN QUERY to run this query and fetch the data from the database.

Once the connection is established, you can see the data imported from the Snowflake to the platform in the table format.

You can manage files, datasets, and published outputs for this data connector across different tabs:

Data Tab: View the files retrieved from this data connector.
Datasets Tab: See the projects where datasets fetched from this data connector have been used.
Schedulers Tab: View the outputs published to this connector. When creating a scheduler, users can configure an external connector as the destination to publish the generated outputs upon job execution.