This problem requires a Pro subscription. Upgrade to access all 15 industry domains and 1,500+ questions.
Upgrade to ProYou are a Data Engineer at T-Mobile. The subscription records contain null end_date values for subscriptions that are still ongoing. Downstream reporting systems cannot handle null dates, so you need to fill in missing end_date values with a far-future sentinel date of 2099-12-31 to indicate that the subscription has no defined end.
You are a Data Engineer at T-Mobile. The subscription records contain null end_date values for subscriptions that are still ongoing. Downstream reporting systems cannot handle null dates, so you need to fill in missing end_date values with a far-future sentinel date of 2099-12-31 to indicate that the subscription has no defined end.