transformations:bulkexportdb
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revision | Last revisionBoth sides next revision | ||
transformations:bulkexportdb [2023/01/19 16:53] – dmitry | transformations:bulkexportdb [2023/10/15 20:59] – updated page style craigt | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ===== Bulk export into database | + | {{ transformations: |
+ | ====== | ||
+ | Category: Export / Database\\ | ||
- | The "Bulk export to database" | + | \\ |
+ | =====Description===== | ||
+ | This action performs fast export into a database table using the native bulk load | ||
capabilities of the target database. The action is intended for exporting large volumes of data (e.g. millions of rows or more) and may not be efficient on small datasets (e.g. with a few hundred of rows). | capabilities of the target database. The action is intended for exporting large volumes of data (e.g. millions of rows or more) and may not be efficient on small datasets (e.g. with a few hundred of rows). | ||
- | Supported target databases: | + | Currently, the following database types are supported: |
^ Database type ^ Driver type ^ | ^ Database type ^ Driver type ^ | ||
- | | SQL Server | + | | BigQuery |
- | | Postgres | + | | Microsoft |
- | | Snowflake | + | | Oracle (experimental) | Native |
- | | BigQuery | + | | PostgreSQL |
+ | | Snowflake | ||
- | ** See also ** | + | A configured connector of the appropriate type is required. |
+ | \\ | ||
+ | =====Action settings===== | ||
+ | ^Setting | ||
+ | |Database type|Select the type of database. | ||
+ | |Connector< | ||
+ | |Table name< | ||
+ | |Column mapping |Select the method for mapping the dataset columns to the fields in the database table.\\ | ||
+ | |||
+ | < | ||
+ | |||
+ | |||
+ | \\ | ||
+ | =====See also===== | ||
+ | * [[transformations: | ||
* [[transformations: | * [[transformations: | ||
* [[transformations: | * [[transformations: | ||
+ | |||
+ |
transformations/bulkexportdb.txt · Last modified: 2023/10/15 21:00 by craigt