How can I integrate Similarweb Batch API reports into a Snowflake account?

Store, access, and analyze Similarweb data directly from your Snowflake database, so you can easily perform queries on your custom reports, or automatically integrate them into your own analytics or visualization tools.

To enable access to the Similarweb Snowflake connector, please speak to a Similarweb representative.

Snowflake integration instructions

The screenshots below are taken from Snowflake's latest user interface (UI), Snowsight. If you are using a different version of the UI, your account might look different.

  1. Retrieve your Snowflake locator ID. This can be found on the platform’s left sidebar.

    Snowflake_LocatorID.png

    Note: Your reports can only be shared to 1 Snowflake ID.

  2. Retrieve your Snowflake region using the following request:

    "select current_region()"

    Snowflake_Region.png

    Note: We support all Snowflake regions.

  3. Once you have your Snowflake locator ID and region, use them to set up the integration via a POST request:

    Note

    URL:

    https://api.similarweb.com/v3/batch/setup-snowflake

    Header:

    API-key: {{your_batch_API_key}}

    Body:

    {

    "snowflake_account_id”: "LOCATOR_ID",

    “snowflake_region”: “SNOWFLAKE_REGION”

    }

    Snowflake_RequestBody.png

    Note: The name of this share will always be “Similarweb_{{your_locator_id}}”.  For example, "Similarweb_2341515".

  4. In your Snowflake account, ensure your role to is set to Account Admin.

    Snowflake_AccountAdmin.png
  5. Navigate to Data > Shared Data.

    Snowflake_SharedData.png

    Locate the new share, and click Get Data.

    Snowflake_GetData.png

    Note: You can still push data into Snowflake without approving the data share, however it won’t be visible until approval.

    This integration requires a one-time setup. Once the above steps are complete, there is no need to repeat the process each time you request a report.

  6. When requesting a Similarweb Batch API report, state where you’d like the data to be delivered using the Request Report endpoint. Input “delivery_method”: “snowflake”.

    Snowflake_DeliveryMethod.png

    Note: When the delivery method is set to “snowflake”, the “response_format” field is not required.

    You should receive “status”: “pending”

  7. Use the Request Report Status endpoint to verify the report is complete (“status”: “completed”). The table names will appear in the response (“snowflake_tables”:)

    Snowflake_RequestReportStatus.png
  8. In Snowflake, from your Worksheet, use the table name to see the report.

    Snowflake_TableName.png

    Each report requested will be viewable under Data > Databases.

    Snowflake_ReportDatabases.png

For technical assistance with this integration, please reach out to your Account Manager.

Was this article helpful?
0 out of 0 found this helpful