Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
This article outlines how to use the copy activity in a pipeline to copy data from MariaDB.
This connector supports MariaDB version 10.x, 11.x.
Supported configuration
For the configuration of each tab under copy activity, go to the following sections respectively.
General
Refer to the General settings guidance to configure the General settings tab.
Source
The following properties are supported for MariaDB under the Source tab of a copy activity.
The following properties are required:
- Connection: Select a MariaDB for Pipeline connection from the connection list. If no connection exists, then create a new MariaDB for Pipeline connection by selecting New.
- Use query: Select from Table or Query.
If you select Table:
- Table: Specify the name of the table in the MariaDB to read data. Select the table from the drop-down list.
If you select Query:
Query: Specify the custom SQL query to read data. For example:
SELECT * FROM MyTable.
Under Advanced, you can specify the following fields:
- Additional columns: Add additional data columns to store source files' relative path or static value. Expression is supported for the latter.
Mapping
For Mapping tab configuration, see Configure your mappings under mapping tab.
Settings
For Settings tab configuration, go to Configure your other settings under settings tab.
Data type mapping for MariaDB
When copying data from MariaDB, the following mappings are used from MariaDB data types to interim data types used by the service internally.
| MariaDB data type | Interim service data type |
|---|---|
| BIGINT | Int64 |
| BIGINT UNSIGNED | UInt64 |
| BIT(1) | UInt64 |
| BIT(M), M>1 | UInt64 |
| BLOB | Byte[] |
| BOOL | Boolean (If TreatTinyAsBoolean=false, it is mapped as SByte. TreatTinyAsBoolean is true by default) |
| CHAR | String |
| DATE | Datetime |
| DATETIME | Datetime |
| DECIMAL | Decimal |
| DOUBLE | Double |
| DOUBLE PRECISION | Double |
| ENUM | String |
| FLOAT | Single |
| INT | Int32 |
| INT UNSIGNED | Int64 |
| INTEGER | Int32 |
| INTEGER UNSIGNED | UInt32 |
| JSON | String |
| LONG VARBINARY | Byte[] |
| LONG VARCHAR | String |
| LONGBLOB | Byte[] |
| LONGTEXT | String |
| MEDIUMBLOB | Byte[] |
| MEDIUMINT | Int32 |
| MEDIUMINT UNSIGNED | UInt32 |
| MEDIUMTEXT | String |
| NUMERIC | Decimal |
| REAL | Double |
| SET | String |
| SMALLINT | Int16 |
| SMALLINT UNSIGNED | UInt16 |
| TEXT | String |
| TIME | TimeSpan |
| TIMESTAMP | Datetime |
| TINYBLOB | Byte[] |
| TINYINT | SByte |
| TINYINT unsigned | Int16 |
| TINYTEXT | String |
| VARCHAR | String |
| YEAR | Int |
Table summary
The following tables contain more information about the copy activity in MariaDB.
Source information
| Name | Description | Value | Required | JSON script property |
|---|---|---|---|---|
| Connection | Your connection to the source data store. | <your MariaDB for Pipeline connection> | Yes | connection |
| Use query | The way to read data from MariaDB. Apply Table to read data from the specified table or apply Query to read data using SQL queries. | • Table • Query |
Yes | / |
| Table | Name of the table in the MariaDB. | < table name > | No | tableName |
| Query | Use the custom SQL query to read data. For example: SELECT * FROM MyTable. |
< SQL queries > | No | query |
| Additional columns | Add additional data columns to store source files' relative path or static value. Expression is supported for the latter. | • Name • Value |
No | additionalColumns: • name • value |