Index of /database/snowflake/FANSIFTER_APP_REPORTING/build/changelog/ddl

Name ↑SizeModified
⬆..📁fanresponse_tasks-2026-09-14 06:27📁routines-2026-09-14 06:27📁tasks-2026-09-14 06:27📄AD-3001_ADD_tags_to_songwhip_fan_consent.sql278 B2026-07-13 14:46📄DATA-5644_CREATE_TEST_TABLE.sql310 B2026-07-13 03:27📄DS-10509-drop-mailing-list-column.sql569 B2026-07-13 03:27📄DS-10509_add_mailing_list_array_to_event_fanresponse_tables.sql597 B2026-07-13 03:27📄DS-11847_add_participant_and_vendor_ids_to_file_upload_campaigns.sql733 B2026-07-13 03:27📄DS-5644_CREATE_TEST_TABLE_II.sql478 B2026-07-13 03:27📄DS-7442_CREATE_EVENT_SMF_FANRESPONSE.sql700 B2026-07-13 03:27📄DS-7446_create_EVENT_FANRESPONSE_tables.sql2.6 KB2026-07-13 03:27📄DS-7479_CREATE_EVENT_SMF_FANRESPONSE_prod.sql346 B2026-07-13 03:27📄DS-7552_alter_EVENT_FANRESPONSE_tables_change_timestamp.sql2.7 KB2026-07-13 03:27📄DS-7590_access_to_jon_fansifter_table_for_RCA_records.sql1.9 KB2026-07-13 03:27📄DS-7813_create_EVENT_FILE_UPLOAD.sql1.0 KB2026-07-13 03:27📄DS-7864_alter_EVENT_FANRESPONSE_tables_add_platform_column.sql723 B2026-07-13 03:27📄DS-7888_alter_EVENT_FANRESPONSE_tables_add_rename_columns.sql1.2 KB2026-07-13 03:27📄DS-7914_create_file_upload_campaigns.sql626 B2026-07-13 03:27📄DS-8024_alter_file_upload_tables_tla_id_column.sql381 B2026-07-13 03:27📄DS-9268_DROP_old_fanresponse.sql467 B2026-07-13 03:27📄DS-9366_data_masking.sql1.3 KB2026-07-13 03:27📄DS-9366_data_masking_songwhip_tables.sql2.8 KB2026-07-13 03:27📄DS-9367_apply_masking_policy_for_songwhip.sql1.8 KB2026-07-13 03:27📄DS-9484_apply_masking_policy_for_event_fan_response.sql11.0 KB2026-07-13 03:27📄DS-9503_DROP_EVENT_WYNG_FANRESPONSE.sql168 B2026-07-13 03:27📄DS-9668_CLONE_EVENT_FANRESPONSE_ON_QA_FROM_PROD.sql618 B2026-07-13 03:27📄FS-1060_UPDATE_subaccount_id_not_null.sql1.1 KB2026-07-13 03:27📄FS-1173_ADD_audience_use_and_refreshed_at_columns.sql478 B2026-07-13 03:27📄FS-1178_ADD_audience_refreshed_by_columns.sql245 B2026-07-13 03:27📄FS-1203_DROP_unused_audience_tables.sql5.0 KB2026-07-13 03:27📄FS-1283-CREATE_sme_shopify_store_view.sql1.3 KB2026-07-13 03:27📄FS-1452_CREATE_delete_unused_snapshot_fans.sql1.2 KB2026-07-13 03:27📄FS-1465_ALTER_suspend_delete_unused_snapshot_fans.sql232 B2026-07-13 03:27📄FS-1588_CREATE_facebook_ad_account_table.sql775 B2026-07-13 03:27📄FS-1589_CREATE_facebook_association_table.sql1018 B2026-07-13 03:27📄FS-1596-create-reporting-tables.sql1.7 KB2026-07-13 03:27📄FS-1794-UPDATE-reporting-tables.sql3.8 KB2026-07-13 03:27📄FS-1798-CREATE_meta_tables.sql4.3 KB2026-07-13 03:27📄FS-1855_DROP_unused_meta_tables.sql5.1 KB2026-07-13 03:27📄FS-2240-CREATE_ad_reporting_op_tables.sql1.4 KB2026-07-13 03:27📄FS-2307_CREATE_ad_reporting_creative_thumbnail_url_table.sql856 B2026-07-13 03:27📄FS-2327-UPDATE_ad_reporting_campaign_artist_table.sql506 B2026-07-13 03:27📄FS-2840-CREATE-songwhip-presave-event-task.sql3.6 KB2026-07-13 03:27📄FS-2850-CREATE-songwhip-fan-consent-event-task.sql3.5 KB2026-07-13 03:27📄FS-2878-CREATE-songwhip-fan-consent-confirm-event-task.sql1.6 KB2026-07-13 03:27📄FS-3170-CREATE-sendgrid-webhook-general-event-task.sql4.0 KB2026-07-13 03:27📄FS-3190-CREATE_email_blocklist_table.sql988 B2026-07-13 03:27📄FS-3234-ALTER_SONGWHIP_PRESAVE_TABLE_ALTER_COLUMN_TYPE.sql649 B2026-07-13 03:27📄FS-3234-ALTER_SONGWHIP_PRESAVE_table_and_task.sql6.3 KB2026-07-13 03:27📄FS-3332_CREATE_EMAIL_ANALYTICS_BY_CAMPAIGN_LIVE_TABLE.sql500 B2026-07-13 03:27📄FS-3333_CREATE_email_analytics_live_task.sql1.5 KB2026-07-13 03:27📄FS-3405-CREATE-sendgrid-webhook-inbound-event-task.sql1.4 KB2026-07-13 03:27📄FS-3537-UPDATE-songwhip-fan-consent-confirm-event-task.sql2.2 KB2026-07-13 03:27📄FS-3586-CREATE-email-campaign-tables.sql2.9 KB2026-07-13 03:27📄FS-3606-RECREATE-email-campaign-tables.sql2.8 KB2026-07-13 03:27📄FS-3612-RECREATE-email-campaign-table.sql1.1 KB2026-07-13 03:27📄FS-3640-ALTER-change-email-campaign-quota-type.sql291 B2026-07-13 03:27📄FS-3665-ADD-email-campaign-cancel-reason.sql488 B2026-07-13 03:27📄FS-3734-ADD-email-campaign-custom-list-id.sql256 B2026-07-13 03:27📄FS-3734-CREATE-custom-list-table.sql324 B2026-07-13 03:27📄FS-3750-UPDATE-email-campaign-global-participant-id.sql294 B2026-07-13 03:27📄FS-3912-CREATE-country-region-city-tables.sql890 B2026-07-13 03:27📄FS-3918-ALTER-audience-fan-cluster-by-snapshot-id.sql316 B2026-07-13 03:27📄FS-3931-ALTER-custom-list-primary-key.sql1.2 KB2026-07-13 03:27📄FS-3946-UPDATE-sendgrid-webhook-general-table.sql1.1 KB2026-07-13 03:27📄FS-3971-ALTER-email-test-send.sql278 B2026-07-13 03:27📄FS-3971-ALTER-sendgrid-general-webhook-task.sql6.1 KB2026-07-13 03:27📄FS-4000-ADD-city-population-column.sql244 B2026-07-13 03:27📄FS-4058-ADD-fails-count-column.sql294 B2026-07-13 03:27📄FS-4208_ADD_artist_roster_tables.sql1.2 KB2026-07-13 03:27📄FS-4294-ALTER-main-rep-table-add-artist-team.sql287 B2026-07-13 03:27📄FS-4400_create_file_upload_deletion_audit.sql437 B2026-07-13 03:27📄FS-4529-ALTER-audience-fan.sql281 B2026-07-13 03:27📄FS-4545_CREATE_EXPORT_APPROVALS_stage.sql1.1 KB2026-07-13 03:27📄FS-4597-add-is-artist-team-column-and-migrate-data.sql796 B2026-07-13 03:27📄FS-4597-convert-artist-roster-tables-to-standard.sql5.6 KB2026-07-13 03:27📄FS-4597_ADD_CREATED_BY_TO_ARTIST_ROSTER_TABLES.sql1.2 KB2026-07-13 03:27📄FS-4597_CREATE_ARTIST_ROSTER.sql713 B2026-07-13 03:27📄FS-4597_CREATE_ARTIST_ROSTER_STREAMS_AND_TASK.sql13.5 KB2026-07-13 03:27📄FS-4597_DROP_old_hybrid_tables.sql1.7 KB2026-07-13 03:27📄FS-4723-CREATE-text-campaign-artist-settings-tables.sql779 B2026-07-13 03:27📄FS-4759_CREATE_url_shortener_click_table_and_task.sql2.2 KB2026-07-13 03:27📄FS-4777-CREATE-text-campaign-table.sql1.2 KB2026-07-13 03:27📄FS-4867-CREATE-text-campaign-attachment-table.sql696 B2026-07-13 03:27📄FS-4881_UPDATE_url_shortener_click_table_and_task.sql2.8 KB2026-07-13 03:27📄FS-4963-ALTER_sendgrid_webhook_general_add_cluster_by_campaign_id.sql316 B2026-07-13 03:27📄FS-4964-ALTER-sendgrid_webhook_general-table-drop-clustering-key.sql306 B2026-07-13 03:27📄FS-4964-ALTER-sendgrid_webhook_general-table-enable-change_tracking.sql329 B2026-07-13 03:27📄FS-4964-CREATE-sendgrid_webhook_general_aggregated-table.sql9.3 KB2026-07-13 03:27📄FS-4975_CREATE_text_campaign_urls_tables.sql1.1 KB2026-07-13 03:27📄FS-5013_CREATE_location_postal_code_table.sql471 B2026-07-13 03:27📄FS-5014_UPDATE_location_city_table.sql888 B2026-07-13 03:27📄FS-5081-create-text-campaign-asset-table.sql767 B2026-07-13 03:27📄FS-5123-add-asset-id-to-text-campaign-artist-settings-table.sql514 B2026-07-13 03:27📄FS-5139-CREATE-url_shortener_clicks-aggregation-tables.sql11.8 KB2026-07-13 03:27📄FS-5144-add-twilio-message-pricing-by-country.sql436 B2026-07-13 03:27📄FS-5156-ALTER-url_shortener_click_table-add-id-olumn.sql3.2 KB2026-07-13 03:27📄FS-5230-ALTER-url_shortener_click_table-add-is_personalized_column.sql3.8 KB2026-07-13 03:27📄FS-5231-make-shortened-url-campaign-id-nullable.sql301 B2026-07-13 03:27📄FS-5289-drop-text-campaign-shortened-url-table.sql127 B2026-07-13 03:27📄FS-5303-ALTER-event_url_shortener_click_task.sql3.8 KB2026-07-13 03:27📄FS-5303-ALTER-url_shortener_click_table-add-is_test-column.sql4.0 KB2026-07-13 03:27📄FS-5315-add-artist-v-card-asset-id-column.sql290 B2026-07-13 03:27📄FS-5317-add-artist-settings-artist-name-column.sql553 B2026-07-13 03:27📄FS-5339-text-message-send-queue-table.sql811 B2026-07-13 03:27📄FS-5466_CREATE_twilio_webhook_outbound_table_and_task.sql2.4 KB2026-07-13 03:27📄FS-5546_CREATE_twilio_webhook_inbound_table_and_task.sql2.0 KB2026-07-13 03:27📄FS-5550-add-twilio-account-specific-columns-to-the-artist-settings-table.sql832 B2026-07-13 03:27📄FS-5570-raname-twilio-message-service-sid-column.sql637 B2026-07-13 03:27📄FS-5613-create-email-campaign-recipient-table.sql405 B2026-07-13 03:27📄FS-5637-change-email-campaign-table-kind-on-qa.sql2.3 KB2026-07-13 03:27📄FS-5638_alter_FAN_DATA_EXPORT_VALUES_AUDIT_change_column_type.sql318 B2026-07-13 03:27📄FS-5658-CREATE-text_campaign_sends_country_aggregated.sql2.1 KB2026-07-13 03:27📄FS-5702-add-audience-target-fans-tables.sql684 B2026-07-13 03:27📄FS-5703_CREATE_email_domain_to_isp_mapping_table.sql7.2 KB2026-07-13 03:27📄FS-5712-add-email-campaign-batch-tables.sql2.5 KB2026-07-13 03:27📄FS-5717-add-email-campaign-delivery-quota-view.sql1.7 KB2026-07-13 03:27📄FS-5721-change-email-campaign-batch-send-record-primary-key-type.sql394 B2026-07-13 03:27📄FS-5727-update-email-campaign-delivery-quota-where-condition.sql1.7 KB2026-07-13 03:27📄FS-5732-ALTER-text_campaign_sends_country_aggregated.sql3.8 KB2026-07-13 03:27📄FS-5840-update-audience-text-fan-table.sql645 B2026-07-13 03:27📄FS-5851_CREATE_SONGWHIP_PAGE_UNLOCK_TABLE.sql2.4 KB2026-07-13 03:27📄FS-5878_ADD_text_campaign_content_scan_result.sql268 B2026-07-13 03:27📄FS-5887_CREATE_virtual_participant.sql960 B2026-07-13 03:27📄FS-5897_ALTER_email_campaign_scheduled_at.sql265 B2026-07-13 03:27📄FS-5912-add-opt-in-message-to-text-campaign-artist-settings.sql269 B2026-07-13 03:27📄FS-5913-add-opt-in-message-to-text-campaign-artist-settings.sql301 B2026-07-13 03:27📄FS-5919_ALTER_email_campaign_add_compressed_content.sql264 B2026-07-13 03:27📄FS-5938-create-table-songwhip_guardian_review.sql2.0 KB2026-07-13 03:27📄FS-5939-UPDATE-event_songwhip_fan_consent_task.sql5.3 KB2026-07-13 03:27📄FS-6031-update-audience-text-fan-table-to-include-more-columns.sql811 B2026-07-13 03:27📄FS-6052-add-sms-timezones-related-table.sql2.8 KB2026-07-13 03:27📄FS-6074_UPDATE_ARTIST_ROSTER_TASK_ADD_1_YEAR_FANS_COUNT.sql12.1 KB2026-07-13 03:27📄FS-6083_ADD_artist_settings_scan_results.sql386 B2026-07-13 03:27📄FS-6144-add-text-campaign-timezone-adjustments-column.sql266 B2026-07-13 03:27📄FS-6205-ALTER-event_url_shortener_click_task.sql3.9 KB2026-07-13 03:27📄FS-6205-ALTER-sendgrid-general-webhook-task-retry.sql5.7 KB2026-07-13 03:27📄FS-6205-ALTER-sendgrid-webhook-inbound-event-task.sql1.6 KB2026-07-13 03:27📄FS-6205-ALTER-sendgrid_webhook_general_table.sql5.9 KB2026-07-13 03:27📄FS-6276-add-tables-for-automated-emails.sql2.2 KB2026-07-13 03:27📄FS-6290-ALTER-sendgrid_webhook_inbound_table.sql2.5 KB2026-07-13 03:27📄FS-6319-ALTER-sendgrid_webhook_general_table.sql6.2 KB2026-07-13 03:27📄FS-6332-update-sendgrid_webhook_general_aggregated-task.sql19.7 KB2026-07-13 03:27📄FS-6348-update-songwhip_fan_consent-table.sql6.1 KB2026-07-13 03:27📄FS-6368-add-email-automated-type-column.sql267 B2026-07-13 03:27📄FS-6369-add-email-automated-trigger-name-column.sql274 B2026-07-13 03:27📄FS-6370-update-email-automated-trigger-table.sql535 B2026-07-13 03:27📄FS-6373-update-automated-emails-schema.sql1.2 KB2026-07-13 03:27📄FS-6374_CREATE_source_campaign_view.sql3.9 KB2026-07-13 03:27📄FS-6402-CREATE-sendgrid_webhook_fan_response-table.sql2.6 KB2026-07-13 03:27📄FS-6405-create-account_to_fan_response_email_address_mapping-table.sql457 B2026-07-13 03:27📄FS-6433-remove-email-automated-unique-index-on-name-and-label.sql151 B2026-07-13 03:27📄FS-6454-delete_email-analytics-by-campaign-live_table.sql657 B2026-07-13 03:27📄FS-6520-alter_CCPA_FAN_LIST_add_requested_at_column.sql1.3 KB2026-07-13 03:27📄FS-6520-CREATE_CCPA_FAN_LIST.sql661 B2026-07-13 03:27📄FS-6638-create-tables-for-briteverify-validation.sql1.1 KB2026-07-13 03:27📄FS-6638-create-unverified-emails-dynamic-table.sql1.5 KB2026-07-13 03:27📄FS-6648_ADD_REQUESTED_BY_TO_ROSTER_AND_VP_TABLES.sql988 B2026-07-13 03:27📄FS-6715-add-subscription-only-column-to-email-automated-trigger-table.sql316 B2026-07-13 03:27📄FS-6804_UPDATE_location_postal_code_table.sql263 B2026-07-13 03:27📄FS-6804_UPDATE_location_postal_code_table_add_place_name.sql241 B2026-07-13 03:27📄FS-6913-alter-songwhip_page_unlock-table-add-id-column.sql4.1 KB2026-07-13 03:27📄FS-7109-renaming-custom-fonts-v2.sql1.0 KB2026-07-13 03:27📄FS-7109-update-email-campaign-and-email-automated-tables.sql516 B2026-07-13 03:27📄FS-7151-update-email-campaign-and-email-automated-tables.sql504 B2026-07-13 03:27📄FS-7174-add-fan-first-name-to-email-campaign-batch-recipient.sql288 B2026-07-13 03:27📄FS-7284-add-has-unapplied-changes-to-email-tables.sql570 B2026-07-13 03:27📄FS-7310_ADD_PROTECTED_RESUBSCRIPTION_TO_VIRTUAL_PARTICIPANT.sql313 B2026-07-13 03:27📄FS-7379_ADD_participant_ids_to_songwhip_fan_consent.sql491 B2026-07-13 03:27📄FS-7427_ADD_crm_mailing_list_id_to_virtual_participant.sql280 B2026-07-13 03:27📄FS-7428_ADD_correlation_id_to_songwhip_fan_consent.sql300 B2026-07-13 03:27📄FS-7524_create_DELETE_BACKOFFICE_FILE_UPLOAD_procedure.sql2.3 KB2026-07-13 14:46📄FS-7524_update_DELETE_FILE_UPLOAD_procedure.sql4.4 KB2026-07-13 14:46📄FS-7539-create-email-reporting-report-tables.sql1.1 KB2026-07-13 03:27📄FS-7550-add-text-campaign-batch-tables.sql2.0 KB2026-07-13 03:27📄FS-7562-remove-unused-columns-from-sms-tables.sql1.2 KB2026-07-13 14:46📄FS-845_CREATE_fansifter_tables.sql10.7 KB2026-07-13 03:27📄FS-960_UPDATE_fansifter_tables.sql4.5 KB2026-07-13 03:27📄FS-988-ADD_audience_id_column.sql273 B2026-07-13 03:27📄FS-988-DROP_unused_tables.sql7.2 KB2026-07-13 03:27📄KDH-391_CREATE_TABLE_EVENT_CAMPAIGN_RAW2.sql357 B2026-07-13 03:27📄KDH-392-CREATE-EVENT_CAMPAIGN_MASTER-tabls.sql3.7 KB2026-07-13 03:27📄KDH-442_create_table_FAN_PROFILE.sql1.8 KB2026-07-13 03:27📄KDH-443-CREATE-PROFILE_ID_MAP-table.sql1.0 KB2026-07-13 03:27📄KDH-447-CREATE-FORM_RESPONSE_TRIGGERED_SEND-TABLE.sql1.5 KB2026-07-13 03:27📄KDH-451-change_fan_response_row_id_type.sql1.3 KB2026-07-13 03:27📄KDH-451-DROP-SMF_FANRESPONSE-TASK.sql345 B2026-07-13 03:27📄KDH-480-EVENT_FANRESPONSE_VALIDATED-ADD-IS_DOI_CONFIRMED.sql377 B2026-07-13 03:27📄KDH-486_create_FAN_SUBSCRIPTION.sql562 B2026-07-13 03:27📄KDH-487_create_FAN_SUBS_LOG.sql1004 B2026-07-13 03:27📄KDH-493_CREATE_TABLE_EVENT_DOI_CONFIRMATIONS.sql980 B2026-07-13 03:27📄KDH-493_CREATE_TABLE_EVENT_DOI_CONFIRMED.sql934 B2026-07-13 03:27📄KDH-494_CREATE-DOI_CONFIRMATIONS-FILE-FORMAT.sql346 B2026-07-13 03:27📄KDH-494_DROP_OLD_DOI_ENTITIES.sql348 B2026-07-13 03:27📄KDH-496_RESUME_PROCESS_FAN_RESPONSE_TASK.sql274 B2026-07-13 03:27📄KDH-513_create_table_MAILING_LIST_V2.sql1.7 KB2026-07-13 03:27📄KDH-513_drop_some_tables.sql243 B2026-07-13 03:27📄KDH-524_DROP_subscirption_log.sql323 B2026-07-13 03:27📄KDH-524_SUBSCRIPTION_CHANGELOG_V2.sql416 B2026-07-13 03:27📄KDH-529_DROP_CRM_FANS_TASKS.sql1.6 KB2026-07-13 03:27📄KDH-529_DROP_FAN_TABLE.sql601 B2026-07-13 03:27📄KDH-658_drop_2arg_unload_to_s3_sp_overload.sql306 B2026-07-13 03:27📄SMF-1019_CREATE_CAMPAIGN_table.sql1.4 KB2026-07-13 03:27