Skip to main content

Create a new Snowflake data warehouse

POST 
/v1/public/data-warehouses/snowflake

Create a new Snowflake data warehouse

Request​

Header Parameters

    Authorization string

Body

required

    name stringrequired

    Possible values: non-empty and <= 128 characters

    connectionId stringrequired

    Possible values: non-empty and <= 128 characters

    access

    object

    required

    users

    object[]

    required

  • Array [

    • userName stringrequired

    Possible values: non-empty

  • ]

    • groups

    object[]

    required

  • Array [

    • name stringrequired

    Possible values: non-empty

  • ]

    • database stringrequired

    Possible values: non-empty

    aggregateSchema stringrequired

    Possible values: non-empty

    connections

    object[]

    required

  • Array [

    • name stringrequired

    Possible values: non-empty

    queryRoles string[]required

    Possible values: [large_user_query_role, small_user_query_role, agg_creation_role, system_query_role, canary_query_role]

    hosts stringrequired

    Possible values: non-empty

    username stringrequired

    Possible values: non-empty

    extraProperties

    object

    required

    warehouse string
    accessType string
    file string

    secretProperties

    object

    nullable

    required

    password nullable
    privateKey string
    passphrase string
    extraJdbcFlags stringrequired

  • ]

Responses​

The data warehouse has been successfully created.

Schema

    created booleanrequired
    id stringrequired
Loading...