Operators

• append operator
  • When to use the append operator
  • Tables have the same schema
  • Tables have different schemas
  • Conflicts
  • Default Datasets
• cleanup operator
  • When to use the cleanup operator
• dataframe operator
  • When to use the dataframe operator
  • Default Datasets
• drop table operator
  • When to use the drop_table operator
• export_to_file operator
  • When to use the export_to_file operator
  • Default Datasets
• get_value_list
  • When to use the get_value_list operator
  • Related references
• load_file operator
  • When to use the load_file operator
  • Parameters to use when loading a file to a database table
  • Inferring a Table Schema
  • Parameters to use when loading a file to a Pandas dataframe
  • Parameters for native transfer
  • Supported native transfers
  • Loading from MinIO
  • Loading to MS SQL
  • Loading to Duckdb
  • Loading to MySQL
  • Patterns in file path
  • Inferring file type
  • Loading data from HTTP API
  • Loading data from SFTP
  • Loading data from FTP
  • Loading data from Azure Blob storage
  • Default Datasets
  • Snowflake Identifier
    • Table
    • Columns
      • Mixed
      • Upper/Lower
  • LoadOptions
• merge operator
  • When to use the merge operator
  • Prerequisites
    • When tables have the same schema
    • When tables have different schemas
  • Conflicts
    • Default Datasets
• run_raw_sql operator
  • When to use the run_raw_sql operator
  • Parameters
• transform operator
  • When to use the transform operator
  • Parameters
• transform_file operator
  • When to use the transform_file operator
  • Parameters
• check_column operator
  • When to use the check_column operator
  • Supported Checks
• check_table operator
  • When to use the check_table operator
  • Supported Checks
• get_file_list
  • When to use the get_file_list operator
  • Related references