Teradata transformation
Application which runs KBC transformations in Teradata DB
Options
authorization
object (required): workspace credentialsparameters
blocks
array (required): list of blocksname
string (required): name of the blockcodes
array (required): list of codesname
string (required): name of the codescript
array (required): list of sql queries
Example Configuration
{
"authorization": {
"workspace": {
"host": "teradata_host",
"user": "teradata_user",
"password": "teradata_password",
"database": "teradata_database",
"schema": "teradata_schema"
}
},
"parameters": {
"blocks": [
{
"name": "first block",
"codes": [
{
"name": "first code",
"script": [
"CREATE TABLE IF NOT EXISTS \"example\" (\"name\" VARCHAR(200),\"usercity\" VARCHAR(200));",
"INSERT INTO \"example\" VALUES ('test example name', 'Prague'), ('test example name 2', 'Brno'), ('test example name 3', 'Ostrava')"
]
}
]
}
]
}
}
Development
Clone this repository and init the workspace with following command:
git clone https://github.com/keboola/teradata-transformation
cd teradata-transformation
docker-compose build
docker-compose run --rm dev composer install --no-scripts
Run the test suite using this command:
docker-compose run --rm dev composer tests
Integration
For information about deployment and integration with KBC, please refer to the deployment section of developers documentation
License
MIT licensed, see LICENSE file.