Explains what the feature is or what its benefits are to the user or customer.
You can add a column to an existing data source using this procedure. This will work even if the data load has already been run in the past.
- A new column has been added to the source table, and you want to include it in the data import.
- You've decided to include an additional column from the source.
- Log in to the Linux shell using SSH.
- Launch TQL.
- Designate the database you'll be working in:
TQL> use <database_name>;
- Find the name of the table you want to change.You can use the TQL command
SHOW TABLES;to see a list of tables.
To see the current sharding on the table, use
SCRIPT TABLE <table_name>;
- Issue the command to change the data type of a column using this syntax:
TQL> ALTER TABLE <schema>.<table> MODIFY COLUMN <column> <new_data_type>;For example, to change "account_id" with data type INT to data type VARCHAR:
TQL> ALTER TABLE foodmart.account ADD COLUMN account_id VARCHAR(10);You must use the fully qualified name of the old table when adding the column via TQL. To find that you can look at the DDL for the data source job itself.
- Run the
SCRIPT TABLEcommand to get the new DDL to create the table.
TQL> SCRIPT TABLE <table>;
Copy the output of the command. Replace any VARCHAR(<number) column definitions with VARCHAR(0), to match the DDL that Data Connect generates. This is the DDL that you will use in your new data source.
- Create a new data source.Be sure to choose the correct columns to match the new target table columns definitions. When you reach the step about editing the generated schema DDL, paste in the DDL that was output by the
- Run the data load and verify that everything is working as it should be.
- If the old data source was running as a recurring load, stop it from running.