Now, let’s explore loading data from an external database using the Snowflake Database data source (the procedure is the same for all our database data sources). We will use our own sample Snowflake database, so do not worry about having to get database credentials from anyone.
Start by going into the Components section and click Add Component.
Use the search box to find the Snowflake data source.
Click Add Component and select Connect To My Data.
Enter a name and a description and click Create Configuration.
Similarly to other components, the Snowflake data source connector can have multiple configurations. As each configuration represents a single database connection, we only need one configuration.
Click Test Connection and Load Available Sources.
Under Select sources, use the dropdown menu to select the
After selecting all the required tables, click Save and Run Configuration. This action will execute the data extraction, generating three new tables in your Storage.
Running the component creates a background job that
For more advanced configuration options, such as incremental fetch, incremental load, or advanced SQL query mode, please navigate to Advanced Mode. Note that we will not cover the advanced mode options in this tutorial.
Proceed to Data Manipulation.
Feel free to reach out to our support team if there’s anything we can help with.
© 2024 Keboola