GitHub - PRQL/prql: PRQL is a modern language for transforming data — a simple, powerful, pipelined SQL replacementYou signed in with another tab or window. Reload to refresh your session. You signed out in another tab or window. Reload to refresh your session. You switched accounts on another tab or window. Reload to refresh your session. Dismiss alert
Advanced SQL Templates In Python with JinjaSql
In A Simple Approach To Templated SQL Queries In Python, I introduced the basics of SQL templates in Python using JinjaSql. This post further demonstrates the power of Jinja2 within JinjaSql templates using presets, loops, and custom functions. Let’s consider an everyday use case when we have a table with some dimensions and some numerical values, and we want to find some metrics for a given dimen
Learn GraphQL Fundamentals with Fullstack Tutorial
GraphQL is a new API standard that provides a more efficient, powerful and flexible alternative to REST. It was developed and open-sourced by Facebook and is now maintained by a large community of companies and individuals from all over the world. APIs have become ubiquitous components of software infrastructures. In short, an API defines how a client can load data from a server. At its core, Grap
CSVå½¢å¼ã®ãƒ‡ãƒ¼ã‚¿ã‚’SQLを使ã£ã¦è§£æžã™ã‚‹ - Qiita
q を利用ã™ã‚‹ã¨ã€CSVã‚„TSVå½¢å¼ã®ãƒ•ã‚¡ã‚¤ãƒ«ã«å¯¾ã—ã¦ç›´æŽ¥SQLを発行ã§ãã¾ã™ã€‚ ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«æ‰‹é † http://harelba.github.io/q/ qを使ã£ãŸãƒ‡ãƒ¼ã‚¿è§£æžã®ä¾‹ 以下ã®æ§˜ãªå—注データã®CSV (ファイルåã¯orders.csv) ãŒæ‰‹å…ƒã«ã‚ã£ãŸæ™‚。 OrderId,OrderDate,ProductID,UserID,Quantity,TotalPrice 10000005,2015/2/13,100,10000,1,10000 10000006,2015/2/13,101,10001,2,2000 10000007,2015/2/13,102,10002,3,6000 10000008,2015/2/13,100,10003,1,10000 10000009,2015/2/13,101,10004,2,2000 10000010,2015/2/14,100,10005
1
ランã‚ング
ランã‚ング
障害
リリースã€éšœå®³æƒ…å ±ãªã©ã®ã‚µãƒ¼ãƒ“スã®ãŠçŸ¥ã‚‰ã›
最新ã®äººæ°—エントリーã®é…ä¿¡
処ç†ã‚’実行ä¸ã§ã™
j次ã®ãƒ–ックマーク
kå‰ã®ãƒ–ックマーク
lã‚ã¨ã§èªã‚€
eコメント一覧を開ã
oページを開ã
Site Under Maintenance
{{#tags}}- {{label}}
{{/tags}}