Snowflake

Snowflake is a cloud-based data warehouse that uses SQL to manage and analyze large amounts of data. It is popular for its speed, easy scaling, and ability to handle big data. Snowflake is often used in business reporting, data analytics, and machine learning.

Connection Properties

In a YAML file, the config section contains the following properties:

Connectorname: Snowflake
user: <>
password: <>
database: <>
account: <>

Example Configuration

version: 1.0.1
encrypt_credentials: true
union_all_tables: true
add_dbname_column: false
plugins:
  extractors:
    - name: Snowflake
      connectorname: Snowflake
      schemaname: 
      config:
        user: <>
        password: <>
        account: <>
        database: <>
      properties: 
      metadata: 
      select:
      - tablename

Configure the Bold Data Hub to connect Snowflake

1. Click the Data Hub icon on the Navigation Pane.

2. Click Add Project and provide the new project’s name.

3. Select the newly created project and add the MySQL template.

Configuration Parameters

Parameters	Description
Username:	Provide the username to authenticate with the Snowflake server.
Password:	Provide the password to authenticate with the Snowflake server.
Account:	Specify the Snowflake account identifier (e.g., xy12345-kc60294).
Database:	Specify the name of the Snowflake database from which data will be extracted.
Schema:	Define the schema within the database where the tables reside.
Select:	Tablename(s): Specify the table name list to load tables from the Snowflake server.
4. Update the details required in the template and Click Save, choose the desired destination to save the pipeline.

5. Creating a Pipeline in Bold Data Hub automatically creates a Data Source in Bold BI. The Bold BI Data Source is a live data source to the destination database used in Bold Data Hub. For more information on the relationship between Bold Data Hub Pipeline and the associated Data Sources in Bold BI , please refer to Relationship between Bold Data Hub Pipeline and Associated Data Sources in Bold BI

Schedule Bold Data Hub Job

1. To configure interval-based scheduling, click on the schedules tab and select the created pipeline and click on the schedule icon and configure it.

2. For on-demand refresh, click Run Now button. . 3. The Schedule history can be checked using the history option as well as logs. 4. Click on Logs to see if the run is completed and data source is created in Bold BI. 5. Click Edit DataSource Option to view the created tables.