Redshift Observatory

System Table Tracker

System view pg_catalog.svv_integration_table_mapping version 1.0.105373 / 2025-01-09

View Text

SELECT DISTINCT stv_integration_mapping.integration_id,
                CAST(CAST('' AS bpchar) AS char(128)) AS source_database,
                stv_integration_mapping.database_name AS target_database,
                stv_integration_mapping.source_schema_name,
                stv_integration_mapping.target_schema_name,
                stv_integration_mapping.source_table_name,
                stv_integration_mapping.target_table_name,
                stv_integration_mapping.source_column_name,
                stv_integration_mapping.target_column_name,
                stv_integration_mapping.source_column_datatype AS source_data_type,
                stv_integration_mapping.target_column_datatype AS target_data_type
FROM stv_integration_mapping
WHERE NOT(stv_integration_mapping.source_schema_name = stv_integration_mapping.target_schema_name
      AND stv_integration_mapping.source_table_name = stv_integration_mapping.target_table_name
      AND stv_integration_mapping.source_column_name = stv_integration_mapping.target_column_name)
  AND stv_integration_mapping.source_column_name IS NOT NULL
  AND stv_integration_mapping.target_column_name IS NOT NULL

Home 3D Друк Blog Bring-Up Times Cross-Region Benchmarks Email Forums Mailing Lists Redshift Price Tracker Redshift Version Tracker Replacement System Tables Reserved Instances Marketplace System Table Tracker The Known Universe White Papers