Tailer Documentation
  • What is Tailer Platform?
  • Getting Started
    • Prepare your local environment for Tailer
    • Install Tailer SDK
    • Set up Google Cloud Platform
    • Encrypt your credentials
  • [Tutorial] Create a first data pipeline
    • Introduction
    • Prepare the demonstration environment
    • Copy files from one bucket to another
    • Load files into BigQuery tables
    • Prepare data
    • Build predictions
    • Export data
    • Congratulations!
    • [Video] Automatic Script
      • SQL script file
      • DDL script file
      • Tables to Tables script file
      • Launch configuration and furthermore
  • Data Pipeline Operations
    • Overview
    • Set constants with Context
      • Context configuration file
    • Move files with Storage to Storage
      • Storage to Storage configuration file
    • Load data with Storage to Tables
      • Storage to Tables configuration file
      • Storage to Tables DDL files
    • Stream incoming data with API To Storage
      • API To Storage configuration file
      • API To Storage usage examples
    • Transform data with Tables to Tables
      • Tables to Tables configuration file
      • Table to Table SQL and DDL files
    • Export data with Tables to Storage
      • [V3] Table to Storage configuration file
      • Table to Storage SQL file
      • [V1-V2: deprecated] Table to Storage configuration file
    • Orchestrate processings with Workflow
      • [V2] Workflow configuration file
      • [V1: deprecated] Workflow configuration file
    • Convert XML to CSV
      • Convert XML to CSV configuration file
    • Use advanced features with VM Launcher
      • Process code with VM Launcher
        • VM Launcher configuration file for code processing
      • Encrypt/Decrypt data with VM Launcher
        • VM Launcher configuration file for data encryption
        • VM Launcher configuration file for data decryption
    • Monitoring and Alerting
      • Monitoring and alerting parameters
    • Asserting Data quality with Expectations
      • List of Expectations
    • Modify files with File Utilities
      • Encrypt/Decrypt data with File Utilities
        • Configuration file for data encryption
        • Configuration file for data decryption
    • Transfer data with GBQ to Firestore
      • Table to Storage: configuration file
      • Table to Storage: SQL file
      • VM Launcher: configuration file
      • File-to-firestore python file
  • Tailer Studio
    • Overview
    • Check data operations' details
    • Monitor data operations' status
    • Execute data operations
    • Reset Workflow data operations
    • Archive data operations
    • Add notes to data operations and runs
    • View your data catalog
    • Time your data with freshness
  • Tailer API
    • Overview
    • Getting started
    • API features
  • Release Notes
    • Tailer SDK Stable Releases
    • Tailer Beta Releases
      • Beta features
      • Beta configuration
      • Tailer SDK API
    • Tailer Status
Powered by GitBook
On this page

Was this helpful?

Edit on GitHub
  1. Release Notes
  2. Tailer Beta Releases

Beta configuration

Table To Storage

{
    "configuration_type" : "table-to-storage",
    "configuration_id" : "demo-nba-v2",
    "environment" : "DEV",
    "account" : "000099",
    "version": "3",
    "activated" : true,
    "archive" : false,
    "gcs_dest_bucket" : "fd-io-demo-n-in",
    "gcs_dest_prefix" : "test_vm_NBA/input",
    "gcp_project_id" : "fd-io-jarvis-demo-dlk",
    "field_delimiter" : "|",
    "compression" : "None",
    "output_filename" : "some_file_name.csv",
    "destination_format": "CSV",
    "copy_table" : false,
    "delete_dest_bucket_content" : false,
    "sql_query_template" : "TEMPLATE_CURRENT_DATE",
    "generate_top_file": false,
    "tasks": [
        {
            "task_id": "job_1",
            "gcs_dest_bucket" : "fd-io-demo-n-in",
            "gcs_dest_prefix" : "test_vm_NBA/input/job_1",
            "gcp_project_id" : "fd-io-jarvis-demo-dlk",
            "field_delimiter" : "|",
            "sql_file" : "job_1.sql",
            "compression" : "None",
            "output_filename" : "some_file_name.csv",
            "generate_top_file": true,
            "destination_format": "CSV",
            "copy_table" : true,
            "delete_dest_bucket_content" : true,
            "sql_query_template" : "TEMPLATE_CURRENT_DATE",
            "dest_gcp_project_id": "fd-io-jarvis-demo-dlk",
            "dest_gbq_dataset": "temp",
            "dest_gbq_table": "test_table",
            "dest_gbq_table_suffix": "dag_execution_date"
        },
        {
            "task_id": "job_2",
            "gcs_dest_bucket" : "fd-io-demo-n-in",
            "gcs_dest_prefix" : "test_vm_NBA/input/job_2",
            "gcp_project_id" : "fd-io-jarvis-demo-dlk",
            "field_delimiter" : "|",
            "sql_file" : "job_2.sql",
            "compression" : "None",
            "output_filename" : "some_file_name.csv",
            "destination_format": "CSV",
            "copy_table" : false,
            "delete_dest_bucket_content" : true,
            "sql_query_template" : "TEMPLATE_CURRENT_DATE"
        },
        {
            "task_id": "job_3",
            "gcs_dest_bucket" : "fd-io-demo-n-in",
            "gcs_dest_prefix" : "test_vm_NBA/input/job_3",
            "gcp_project_id" : "fd-io-jarvis-demo-dlk",
            "field_delimiter" : "|",
            "sql_file" : "job_2.sql",
            "compression" : "None",
            "output_filename" : "some_file_name.csv",
            "destination_format": "CSV",
            "copy_table" : false,
            "delete_dest_bucket_content" : true,
            "sql_query_template" : "TEMPLATE_CURRENT_DATE"
        },
        {
            "task_id": "job_4",
            "gcs_dest_bucket" : "fd-io-demo-n-in",
            "gcs_dest_prefix" : "test_vm_NBA/input/job_4",
            "gcp_project_id" : "fd-io-jarvis-demo-dlk",
            "field_delimiter" : "|",
            "sql_file" : "job_2.sql",
            "compression" : "None",
            "output_filename" : "some_file_name.csv",
            "destination_format": "CSV",
            "copy_table" : false,
            "delete_dest_bucket_content" : true,
            "sql_query_template" : "TEMPLATE_CURRENT_DATE"
        },
        {
            "task_id": "job_5",
            "gcs_dest_bucket" : "fd-io-demo-n-in",
            "gcs_dest_prefix" : "test_vm_NBA/input/job_5",
            "gcp_project_id" : "fd-io-jarvis-demo-dlk",
            "field_delimiter" : "|",
            "sql_file" : "job_2.sql",
            "compression" : "None",
            "output_filename" : "some_file_name.csv",
            "destination_format": "CSV",
            "copy_table" : false,
            "delete_dest_bucket_content" : true,
            "sql_query_template" : "TEMPLATE_CURRENT_DATE"
        },
        {
            "task_id": "job_6",
            "gcs_dest_bucket" : "fd-io-demo-n-in",
            "gcs_dest_prefix" : "test_vm_NBA/input/job_6",
            "gcp_project_id" : "fd-io-jarvis-demo-dlk",
            "field_delimiter" : "|",
            "sql_file" : "job_2.sql",
            "compression" : "None",
            "output_filename" : "some_file_name.csv",
            "destination_format": "CSV",
            "copy_table" : false,
            "delete_dest_bucket_content" : true,
            "sql_query_template" : "TEMPLATE_CURRENT_DATE"
        },
        {
            "task_id": "job_7",
            "gcs_dest_bucket" : "fd-io-demo-n-in",
            "gcs_dest_prefix" : "test_vm_NBA/input/job_7",
            "gcp_project_id" : "fd-io-jarvis-demo-dlk",
            "field_delimiter" : "|",
            "sql_file" : "job_2.sql",
            "compression" : "None",
            "output_filename" : "some_file_name.csv",
            "destination_format": "CSV",
            "copy_table" : false,
            "delete_dest_bucket_content" : true,
            "sql_query_template" : "TEMPLATE_CURRENT_DATE"
        },
        {
            "task_id": "job_8",
            "gcs_dest_bucket" : "fd-io-demo-n-in",
            "gcs_dest_prefix" : "test_vm_NBA/input/job_8",
            "gcp_project_id" : "fd-io-jarvis-demo-dlk",
            "field_delimiter" : "|",
            "sql_file" : "job_2.sql",
            "compression" : "None",
            "output_filename" : "some_file_name.csv",
            "destination_format": "CSV",
            "copy_table" : false,
            "delete_dest_bucket_content" : true,
            "sql_query_template" : "TEMPLATE_CURRENT_DATE"
        },
        {
            "task_id": "job_9",
            "gcs_dest_bucket" : "fd-io-demo-n-in",
            "gcs_dest_prefix" : "test_vm_NBA/input/job_9",
            "gcp_project_id" : "fd-io-jarvis-demo-dlk",
            "field_delimiter" : "|",
            "sql_file" : "job_2.sql",
            "compression" : "None",
            "output_filename" : "some_file_name.csv",
            "destination_format": "CSV",
            "copy_table" : false,
            "delete_dest_bucket_content" : true,
            "sql_query_template" : "TEMPLATE_CURRENT_DATE"
        },
        {
            "task_id": "job_10",
            "gcs_dest_bucket" : "fd-io-demo-n-in",
            "gcs_dest_prefix" : "test_vm_NBA/input/job_10",
            "gcp_project_id" : "fd-io-jarvis-demo-dlk",
            "field_delimiter" : "|",
            "sql_file" : "job_2.sql",
            "compression" : "None",
            "output_filename" : "some_file_name.csv",
            "destination_format": "CSV",
            "copy_table" : false,
            "delete_dest_bucket_content" : true,
            "sql_query_template" : "TEMPLATE_CURRENT_DATE"
        }
    ]
}
PreviousBeta featuresNextTailer SDK API

Last updated 1 year ago

Was this helpful?