Explain the different methods for loading data into Snowflake.

Snowflake offers several data loading methods:
1. COPY Command:

• Primary method for bulk loading
• Loads from staged files (internal/external stages)
• Supports various file formats (CSV, JSON, Parquet, etc.)
  2. Snowpipe:
• Near real-time data ingestion
• Event-driven, serverless data loading
• Automatically loads data when files arrive in stage
  3. INSERT Statements:
• For small amounts of data
• Direct row-by-row insertion
• Can insert from other tables or VALUES clause
  4. Third-party ETL Tools:
• Integration with tools like Informatica, Talend, Matillion
• Native connectors available
  Example COPY command:

COPY INTO my_table
FROM @my_stage/data_file.csv
FILE_FORMAT = (TYPE = 'CSV' SKIP_HEADER = 1);