Reload a Connector Schema Config
Reloads the connector schema config for an existing connector within your Fivetran account.
NOTE: This method reloads the full schema from the connector's data source. It may take a long time to complete the request. The method execution speed depends on the schema size and the number of databases, tables and columns. To retrieve the connector schema config without reload, use the Retrieve a Connector Schema Config endpoint.
The response contains only the difference between your selections and the schema config. The schema config includes schemas, tables, and columns. If you have not specified any schema configurations that differ from the default, the response will consist of only the top schema level. For more information, see also the Connector Schema config tutorial.
Request schema
Path parameters
The unique identifier for the connector within the Fivetran system
Header parameters
HTTP: basicAuth
HTTP AuthorizationScheme: basic
Request
Specifies whether all schemas and tables will be enabled or disabled in the standard config. By specifying the exclude_mode parameter value, you can enable or disable syncing for all schemas and tables when reloading the connector schema config.
When the default PRESERVE value is set, all selected schemas and tables in the standard config preserve their state.
When the EXCLUDE value is set, the columns that haven't been modified by user yet are not excluded from the sync. Such columns may be present in the source and not displayed in the response, but they are considered to be included in the sync by default. If you enable syncing of their table, then all of these columns from the source will be synced in the next sync cycle. See also Troubleshooting: How to enable syncs only for the columns you need.
POST /v1/connectors/connector_id/schemas/reload HTTP/1.1
Accept: application/json
Authorization: Basic REPLACE_BASIC_AUTH
Content-Type: application/json
Host: api.fivetran.com
Content-Length: 32
{
"exclude_mode": "PRESERVE"
}Responses
Successful response schema
Response status code
Response status text
The boolean value specifying whether to enable new schemas, tables, and columns by default
The set of schemas within your connector schema config that are synced into the destination
additional property
The schema name within your destination in accordance with Fivetran conventional rules
The boolean value specifying whether the sync for the table into the destination is enabled.
The set of tables within your database schema config that are synced into the destination
additional property
This field appears in the response if the connector supports switching sync modes for tables
The schema name within your destination in accordance with Fivetran conventional rules
The boolean value specifying whether the sync for the table into the destination is enabled.
The set of columns within your table schema config that are synced into the destination
additional property
The schema name within your destination in accordance with Fivetran conventional rules
The boolean value specifying whether the sync for the table into the destination is enabled.
The boolean value specifying whether a column should be hashed
The boolean value specifying whether the enabled property can be modified
The additional message indicating the reason why the enabled property cannot be modified. This field appears in the response only when the reason_code value is OTHER
The reason code indicating the reason why the enabled property cannot be modified:
SYSTEM_TABLE - the table is a system table
DELETED - the table was deleted in the source
OTHER - the table was excluded by the system for some reason
This field appears in the response when the allowed property value is FALSE
The boolean value specifying whether the enabled property can be modified
The additional message indicating the reason why the enabled property cannot be modified. This field appears in the response only when the reason_code value is OTHER
The reason code indicating the reason why the enabled property cannot be modified:
SYSTEM_TABLE - the table is a system table
DELETED - the table was deleted in the source
OTHER - the table was excluded by the system for some reason
This field appears in the response when the allowed property value is FALSE
The possible values for the schema_change_handling parameter are as follows:
ALLOW_ALL - all new schemas, tables, and columns which appear in the source after the initial setup are included in syncs
ALLOW_COLUMNS - all new schemas and tables which appear in the source after the initial setup are excluded from syncs, but new columns are included
BLOCK_ALL - all new schemas, tables, and columns which appear in the source after the initial setup are excluded from syncs
{
"code": "Success",
"message": "Operation performed.",
"data": {
"enable_new_by_default": true,
"schemas": {
"property1": {
"name_in_destination": "schema_name_in_destination",
"enabled": true,
"tables": {
"property1": {
"sync_mode": "SOFT_DELETE",
"name_in_destination": "table_name_in_destination",
"enabled": true,
"columns": {
"property1": {
"name_in_destination": "column_name_in_destination",
"enabled": true,
"hashed": false,
"enabled_patch_settings": {
"allowed": false,
"reason": "...",
"reason_code": "SYSTEM_COLUMN"
},
"is_primary_key": true
},
"property2": {
"name_in_destination": "column_name_in_destination",
"enabled": true,
"hashed": false,
"enabled_patch_settings": {
"allowed": false,
"reason": "...",
"reason_code": "SYSTEM_COLUMN"
},
"is_primary_key": true
}
},
"enabled_patch_settings": {
"allowed": false,
"reason": "...",
"reason_code": "SYSTEM_TABLE"
},
"supports_columns_config": true
},
"property2": {
"sync_mode": "SOFT_DELETE",
"name_in_destination": "table_name_in_destination",
"enabled": true,
"columns": {
"property1": {
"name_in_destination": "column_name_in_destination",
"enabled": true,
"hashed": false,
"enabled_patch_settings": {
"allowed": false,
"reason": "...",
"reason_code": "SYSTEM_COLUMN"
},
"is_primary_key": true
},
"property2": {
"name_in_destination": "column_name_in_destination",
"enabled": true,
"hashed": false,
"enabled_patch_settings": {
"allowed": false,
"reason": "...",
"reason_code": "SYSTEM_COLUMN"
},
"is_primary_key": true
}
},
"enabled_patch_settings": {
"allowed": false,
"reason": "...",
"reason_code": "SYSTEM_TABLE"
},
"supports_columns_config": true
}
}
},
"property2": {
"name_in_destination": "schema_name_in_destination",
"enabled": true,
"tables": {
"property1": {
"sync_mode": "SOFT_DELETE",
"name_in_destination": "table_name_in_destination",
"enabled": true,
"columns": {
"property1": {
"name_in_destination": "column_name_in_destination",
"enabled": true,
"hashed": false,
"enabled_patch_settings": {
"allowed": false,
"reason": "...",
"reason_code": "SYSTEM_COLUMN"
},
"is_primary_key": true
},
"property2": {
"name_in_destination": "column_name_in_destination",
"enabled": true,
"hashed": false,
"enabled_patch_settings": {
"allowed": false,
"reason": "...",
"reason_code": "SYSTEM_COLUMN"
},
"is_primary_key": true
}
},
"enabled_patch_settings": {
"allowed": false,
"reason": "...",
"reason_code": "SYSTEM_TABLE"
},
"supports_columns_config": true
},
"property2": {
"sync_mode": "SOFT_DELETE",
"name_in_destination": "table_name_in_destination",
"enabled": true,
"columns": {
"property1": {
"name_in_destination": "column_name_in_destination",
"enabled": true,
"hashed": false,
"enabled_patch_settings": {
"allowed": false,
"reason": "...",
"reason_code": "SYSTEM_COLUMN"
},
"is_primary_key": true
},
"property2": {
"name_in_destination": "column_name_in_destination",
"enabled": true,
"hashed": false,
"enabled_patch_settings": {
"allowed": false,
"reason": "...",
"reason_code": "SYSTEM_COLUMN"
},
"is_primary_key": true
}
},
"enabled_patch_settings": {
"allowed": false,
"reason": "...",
"reason_code": "SYSTEM_TABLE"
},
"supports_columns_config": true
}
}
}
},
"schema_change_handling": "ALLOW_ALL"
}
}