How would you approach resolving this issue?

A SQL Dashboard was built for the supply chain team to monitor the inventory and product orders, but all of the timestamps displayed on the dashboards are showing in UTC format, so they requested to change the time zone to the location of New York.

How would you approach resolving this issue?
A . Move the workspace from Central US zone to East US Zone
B . Change the timestamp on the delta tables to America/New_York format
C . Change the spark configuration of SQL endpoint to format the timestamp to Ameri-ca/New_York
D . Under SQL Admin Console, set the SQL configuration parameter time zone to Ameri-ca/New_York
E . Add SET Timezone = America/New_York on every of the SQL queries in the dashboard.

Answer: D

Explanation:

The answer is, Under SQL Admin Console, set the SQL configuration parameter time zone to America/New_York

Here are steps you can take this to configure, so the entire dashboard is changed without

changing individual queries

Configure SQL parameters

To configure all warehouses with SQL parameters:

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments