Push data to a SQL table.

The client sends data encoded using the format specified in the ?format= parameter as a body of the request. The contents of the data must match the SQL table schema specified in table_name

The pipeline ingests data as it arrives without waiting for the end of the request. Successful HTTP response indicates that all data has been ingested successfully.

Path Parameters
pipeline_name string — REQUIRED Unique pipeline name
table_name string — REQUIRED SQL table name. Unquoted SQL names have to be capitalized. Quoted SQL names have to exactly match the case from the SQL program.

Query Parameters
force boolean — REQUIRED When true, push data to the pipeline even if the pipeline is paused. The default value is false
format string — REQUIRED Input data format, e.g., 'csv' or 'json'.
array boolean Set to true if updates in this stream are packaged into JSON arrays (used in conjunction with format=json). The default values is false.
update_format string Possible values: [insert_delete, weighted, debezium, snowflake, raw] Supported JSON data change event formats. Each element in a JSON-formatted input stream specifies an update to one or more records in an input table. We support several different ways to represent such updates. JSON data change event format (used in conjunction with format=json). The default value is 'insert_delete'.

Request Body — REQUIRED Contains the new input data in CSV.
string

Responses
200 Data successfully delivered to the pipeline.
400 Error parsing input data. Schema — OPTIONAL details object Detailed error metadata. The contents of this field is determined by error_code. error_code string Error code is a string that specifies this error type. message string Human-readable error message.
404 Pipeline is not currently running because it has been shutdown or not yet started. Schema — OPTIONAL details object Detailed error metadata. The contents of this field is determined by error_code. error_code string Error code is a string that specifies this error type. message string Human-readable error message.
500 Request failed. Schema — OPTIONAL details object Detailed error metadata. The contents of this field is determined by error_code. error_code string Error code is a string that specifies this error type. message string Human-readable error message.