td_ddl>: Treasure Data operations

td_ddl> operator runs an operational task on Treasure Data.

_export:
  td:
    database: www_access

+step1:
  td_ddl>:
  create_tables: ["my_table_${session_date_compact}"]
+step2:
  td_ddl>:
  drop_tables: ["my_table_${session_date_compact}"]
+step3:
  td_ddl>:
  empty_tables: ["my_table_${session_date_compact}"]
+step4:
  td_ddl>:
  rename_tables: [{from: "my_table_${session_date_compact}", to: "my_table"}]

Secrets

  • td.apikey: API_KEY

    The Treasure Data API key to use when performing Treasure Data operations.

Options

  • create_tables: [ARRAY OF NAMES]

    Create new tables if not exists.

    Examples:

    create_tables: [my_table1, my_table2]
    
  • empty_tables: [ARRAY OF NAME]

    Create new tables (drop it first if it exists).

    Examples:

    empty_tables: [my_table1, my_table2]
    
  • drop_tables: [ARRAY OF NAMES]

    Drop tables if exists.

    Examples:

    drop_tables: [my_table1, my_table2]
    
  • rename_tables: [ARRAY OF {to:, from:}]

    Rename a table to another name (override the destination table if it already exists).

    Examples:

    rename_tables: [{from: my_table1, to: my_table2}]
    
  • create_databases: [ARRAY OF NAMES]

    Create new databases if not exists.

    Examples:

    create_databases: [my_database1, my_database2]
    
  • empty_databases: [ARRAY OF NAME]

    Create new databases (drop it first if it exists).

    Examples:

    empty_databases: [my_database1, my_database2]
    
  • drop_databases: [ARRAY OF NAMES]

    Drop databases if exists.

    Examples:

    drop_databases: [my_database1, my_database2]
    
  • endpoint: ADDRESS

    API endpoint (default: api.treasuredata.com).

  • use_ssl: BOOLEAN

    Enable SSL (https) to access to the endpoint (default: true).