How is the PPU determined using a sandbox? I assume I'll start a workspace by uploading data or querying. Is the time set for automatic sleep? Can I switch it to sleep mode?
126
BI Manager @ KofolaLog in to ask Radek Hajek questions publicly or anonymously.
How is the PPU determined using a sandbox? I assume I'll start a workspace by uploading data or querying. Is the time set for automatic sleep? Can I switch it to sleep mode?
Hi,
sometimes the Power BI dataset refresh through this application does not work. I was unable to determine the cause of this anomaly.
Does anyone have a similar problem or solution to what?
Radek
TIP for use: I needed to find our nearest customer for potential customers. A simple solution is offered by SQL function HAVERSINE, which calculates the distance between two geo points.
In the first SELECT, you create an array of known points x unknown. Use the function to calculate the distance. In the Second SELECT, you sort by distances and select the nearest one.
Special thanks to Samuel for help.
Snowflake Documentation.