AWS Redshift
Post in
四 30 十一月 2023
Encode
Amazon Redshift AZ64、LZO、ZSTD 字段的支持类型
| Type Category | Type | LZO | SZTD | AZ64 |
|---|---|---|---|---|
| SMALLINT | INT2 | Yes | Yes | Yes |
| INTEGER | INT、INT4 | Yes | Yes | Yes … |
Precision Medicine — iDiscover Data Platform
Post in 三 08 十一月 2023
SWIFT — Supply Chain Data Modeling
Post in 三 08 十一月 2023
Salesforce
Post in 一 06 十一月 2023https://developer.salesforce.com/docs/atlas.en-us.soql_sosl.meta/soql_sosl/sforce_api_calls_soql_select.htm
SOQL
SELECT FIELDS(ALL) FROM FROM < Object> limit 10SELECT count() FROM < Object>
ExcelJS
Post in 三 26 七月 2023ExcelJS 是一个 Node.js 模块，可用来读写和操作 XLSX 和 JSON 电子表格数据和样式。
import ExcelJS …
Synapse SQL
Post in 二 30 五月 2023Synapse SQL
- 无法插入多条数据
INSERT INTO "user_generated_events" (event_id) VALUES ('1'), ('2')error: QueryFailedError: Error: Parse error at line: 1, column: 325: Incorrect syntax near …
Databricks Machine Learning
Post in 三 17 五月 2023Databricks 机器学习
数据仓库 Data Warehouse：
Structured Data -> ETL -> Data Warehouse -> Business Intelligence
e.g. snowflake, Azure Synapse Analytics, amazon REDSHIFT, Goodle Big Query
- 通 …
Microsoft Azure Databricks API
Post in 一 15 五月 2023https://docs.databricks.com/api-explorer/workspace/jobs
Step0: Connection variables
Compute → Cluster → Configuration → Advanced options → JDBC/ODBC
-
Databricks_HOST: adb-xxx.azuredatabricks.net
-
HTTP Path: sql/protocolv1/o/6201908139262714/xxxx
-
Cluster_ID: xxxx …
-
NEO4J
Post in 五 28 四月 2023Neo4j Desktop
https://neo4j.com/download/
图数据库
Neo4j是一个高性能的,NOSQL图形数据库，它将结构化数据存储在网络上而不是表中 …
SSO 登录
Post in 二 18 四月 2023+--------+ +---------------+ | |--(A)- Authorization Request ->| Resource | | | | Owner | | |<-(B)-- Authorization Grant ---| | | | +---------------+ | | | | +---------------+ | |--(C)-- Authorization Grant -->| Authorization | | Client | | Server | | |<-(D)----- Access Token -------| | | | +---------------+ | | | | +---------------+ | |--(E)----- Access Token ------>| Resource | | | | Server | | |<-(F)--- Protected Resource ---| | +--------+ +---------------+Step1 Get code
[GET] https …