NiladriMallik/Incubyte-SkyPoints-DE-Assessment ? reverse-engineered prompt

Build me an end to end data pipeline for this SkyPoints airline loyalty assessment.

I want it to load a daily pipe delimited member file and a daily JSON redemption feed from Azure Data Lake into Snowflake, then transform everything with dbt into a clean bronze, silver, and gold flow. Please create the raw landing tables, staging logic, and the final member tables split by country. Also add the business rules from the brief, like deriving age, flagging stale members when the last flight was over 90 days ago, and making sure the latest record wins when a member changes country.

For the redemption feed, flatten the nested JSON into a queryable table and join it back to the member profile data. Keep bad records flagged instead of silently dropping them, and add solid data quality checks for required fields, uniqueness, and obvious sample data issues. If you need to, look up current Snowflake and dbt docs online to make sure the setup is realistic.