Configuration
There is a Snowflake connector in Power Platform to connecto to Snowflake database using Snowflake API calls. To be able to use the Snowflake connector, Azure AD (Entra ID) authentication for Snowflake needs to be setup on Snowflake side. Follow Getting started with Power Apps and Snowflake on how to configure the Azure AD authentication for Snowflake.
timestamp value
In Snowflake Power Platform connector, the timestamp_ntz data type represents a timestamp in UTC time zone without time zone offset information. It’s a UNIX timestamp. The common base date for UNIX timestamp is January 1, 1970. Using following query to convert the unix timestamp value to standard date/datetime value in MS SQL.
--17898632.0000 is the unix format value
SELECT DATEADD(SECOND, 17898632.0000, '19700101')
FEATURED TAGS
ai
api
automation
availability
availability sets
availability zones
aws vm
azure
azure automation runbook
azure blob
azure cosmos db
azure data lake
azure function app
azure openai
azure sign-in
azure site recovery
azure sql database
azure sql db
azure subscription
azure vm
base64
certificate
change data capture
change tracking
chrome
clr
container
cte
data api builder
data conversion
data gateway
database role
database size
date table
dax
db config
derived table
diagram
direct query
disk management
disk space
docker
downtime
dtc
dynamic m parameter
embedding
encrypted connection
excel
excel online
execution plan
extended events
external data
fabric
fabric capacity
failover cluster
fk
geometry
hierarchy
httpwebrequest
hugo
hyper-v
incognito mode
index
infrastructure
inline tvf
json
kql
lakehouse
linked server
live query statistics
locking
m
machine learning
machine learning model
machine learning services
master key
mcp
mdx
memory
memory grant
mermaid
mirrored sql server
network
network card
network category
onedrive
onnx runtime
openrowset
p2v
parquet
performance
polybase
power automate
power bi
power bi report tricks
power platform
power query
powershell
printer
public ip address
pyspark
python
qgis
qt designer
query performance
query plan
query troubleshooting
r
regex
replication
route
s3
schema design
scripting
self-signed certificate
server role
sharepoint
snowflake
software development
sofware development
spark
sql
sql agent
sql availability group
sql error
sql failover cluster instance
sql index
sql openjson
sql permission
sql recovery
sql script
sql security
sql server
sql server admin
sql server config
sql statistics
ssis
ssisdb
ssl
ssl/tls error
ssms
table expression
tempdb
tips
troubleshooting
unicode
view
visual studio
visual studio code
vmware
wait statistics
wi-fi connection issue
windows settings