# Guess DWH Integration configuration

Perform Guess operation for complete DWH Integration configuration by providing basic_configs.

Endpoint: POST /v1/guess
Version: 1.0.0
Security: apiKey

## Request fields (application/json):

  - `basic_configs` (object) — one of (discriminator: type):
    The basic configs of the DWH Integration.
    - snowflake:
      - `type` (string, required)
        Connector type
      - `td_authentication_id` (string, required)
        The existing Connector Authentication ID
      - `role` (string)
        Specify the role name, Leave blank to use default role.
      - `warehouse` (string, required)
        The Snowflake data Warehouse to use for the connection, e.g. "COMPUTE_WH"
      - `db` (string, required)
      - `schema` (string, required)
        The schema to use for the connection
      - `incremental` (boolean)
        Enable incremental loading for this connector
    - databricks:
      - `type` (string, required)
        Connector type
      - `td_authentication_id` (string, required)
        The existing Connector Authentication ID
      - `catalog` (string, required)
      - `schema` (string)
        The schema to use for the connection. If not specified, default schema will be used.
      - `incremental` (boolean)
        Enable incremental loading for this connector. If this is enabled, you must specify the incremental_columns or Bulkload job will fail.

## Response 200 fields (application/json):

  - `basic_configs` (object) — one of (discriminator: type):
    The basic configs of the DWH Integration.
    - snowflake:
      - `type` (string, required)
        Connector type
      - `td_authentication_id` (string, required)
        The existing Connector Authentication ID
      - `role` (string)
        Specify the role name, Leave blank to use default role.
      - `warehouse` (string, required)
        The Snowflake data Warehouse to use for the connection, e.g. "COMPUTE_WH"
      - `db` (string, required)
      - `schema` (string, required)
        The schema to use for the connection
      - `incremental` (boolean)
        Enable incremental loading for this connector
    - databricks:
      - `type` (string, required)
        Connector type
      - `td_authentication_id` (string, required)
        The existing Connector Authentication ID
      - `catalog` (string, required)
      - `schema` (string)
        The schema to use for the connection. If not specified, default schema will be used.
      - `incremental` (boolean)
        Enable incremental loading for this connector. If this is enabled, you must specify the incremental_columns or Bulkload job will fail.

  - `advanced_configs` (array)
    The DWH Integration advanced configs. The configs contain array of 
of table configs which combine with the basic configs will be used to create Connector Bulkload Session.

  - `advanced_configs.target_table` (string)
    The name of the TD table to import data into.

  - `advanced_configs.config` (object) — one of (discriminator: type):
    The configuration which will merge with the basic_configs to form a complete Connector configuration for Bulkload job.
Some of the config from the basic_configs can declare here to override the basic_configs.
    - snowflake:
      - `type` (string)
        Connector type, e.g. snowflake, redshift
      - `source_type` (string)
        Specify the import type, either via a table/view or via a query.
        Enum: "table_view", "query"
      - `query` (string)
        Use with (source_type: query) to specify a custom query for importng.
      - `select` (string)
        Comma-separated list of columns to SELECT. Use with (source_type: table_view) to query for columns
      - `table` (string)
        The table/view to import from. Use with (source_type: table_view)
      - `where` (string)
        Specify a WHERE condition to filter the data
      - `order_by` (string)
        Specify the columns to order the data by
      - `incremental` (boolean)
        Enable incremental loading for this connector?
      - `incremental_columns` (array)
        List of column(s) to incremental on. Only timestamp and numeric columns are accepted. 
If not set, it will try to find and use the primary keys
      - `invalid_value_option` (string)
        Specify how to handle invalid data values.
        Enum: "fail_job", "insert_null", "ignore_row"
    - databricks:
      - `type` (string)
        Connector type, e.g. snowflake, redshift
      - `use_custom_query` (boolean)
        If you need more than a simple SELECT (columns) FROM table WHERE (condition).
      - `query` (string)
        Use with (use_custom_query: true) to specify a custom query for importing.
      - `select` (string)
        Comma-separated list of columns to ingest. Use with (use_custom_query: false) to query for columns.
      - `table` (string)
        The table/view to import from. Use with (use_custom_query: false)
      - `where` (string)
        Specify a WHERE condition to filter the data. Use with (use_custom_query: false)
      - `order_by` (string)
        Specify the columns to order the data by. Use with (use_custom_query: false)
      - `incremental` (boolean)
        Enable incremental loading for this connector?
      - `incremental_columns` (array)
        List of column(s) to incremental on. Only timestamp and numeric columns are accepted. 
If not set, it will try to find and use the primary keys
      - `invalid_value_option` (string)
        Specify how to handle invalid data values.
        Enum: same as `invalid_value_option` in "snowflake" (3 values)
      - `last_record` (array)
        Values for columns used in incremental loading. Ignores records with column values less than this
        Enum: "string", "number", "boolean", "null"

## Response 400 fields (application/json):

  - `error` (object)

  - `error.code` (integer)
    The HTTP status code

  - `error.title` (string)
    The error title

  - `error.message` (any)
    The error message

  - `error.detail` (object)
    Any extra infomation of the error