Importing data from Snowflake
Last updated
Last updated
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.
Password: The password for the user account.
Account: The name of the account.
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.
