Snowflake

Snowflake is a cloud-based data warehouse that is not only easier to use but also faster, reliable, and flexible when compared to traditional data warehouses.

Actions

  • Add Row: Add a new row to a specific database

  • Create Database: Create a new database

  • Create File Format: Create a new file format in a specific database

  • Delete Row: Delete a row from a table of a specific database

  • Execute Query: Execute an SQL query

  • Get Rows: Retrieves the details of a single or multiple rows from a table of a specific database

  • Load Table: Load data files into a table of a specific database

    Note: Currently, this action loads data files from only one external location, Amazon S3 bucket.
  • Update Row: Update a row of a specific database

Common Questions

How to find the account name for Snowflake

To find the account name for your Snowflake account, do the following:

  • Login to your Snowflake account.
  • At the lower-left corner of the navigation bar, click the Account Selector option.

    This option lists accounts you have been signed in to.

  • Hover over the account for the account name you want to retrieve. A pop-up window appears displaying the account-related information.

  • Click the Copy to Clipboard icon. Doing so will copy the account URL to your clipboard.

    The account URL contains the account name associated with your Snowflake account. If your account URL is https://ab68494.ac-south-1.aws.snowflakecomputing.com, the account name is ab68494.ac-south-1.aws.