Itt project_id arg van es JO a UI-rol kimasolhato string a querybe (59-es sor)
Ez egy kulon jobot csinal, az IAM-ban a service accountnak kell a
bigquery.datasets.create ES a bigquery.jobs.create jog.
Ez nem tud queryzni csak vegigmegy az egesz tablan, eleg a BigQuery Read Session User jog az IAM-ban a service accountnak.
A --table_spec ems-plugins:sap_cc_products_test_dataset.sap_cc_products_test_table
!!!! KETTOSPONTTAL !!!!
mukodik csak a project neve utan, amit a kibaszott Cloud Console UI a vagolapra masol ott PONT van es NEM jo.
| """A streaming workflow for Pubsub to BigTable transfer | |
| """ | |
| # pytype: skip-file | |
| from apache_beam.options.pipeline_options import StandardOptions | |
| from apache_beam.options.pipeline_options import SetupOptions | |
| from apache_beam.options.pipeline_options import PipelineOptions | |
| from apache_beam.io.gcp.bigtableio import WriteToBigTable | |
| from google.cloud.bigtable import row |
| --- | |
| title: Push the button - Getting Started With IoT & MQTT | |
| published: false | |
| description: Creating an IoT button from scratch for beginners | |
| tags: arduino,iot,mqtt,esp32 | |
| cover_image: https://dev-to-uploads.s3.amazonaws.com/i/j8i605vntq9x76ge8dtt.jpg | |
| series: Push the button | |
| --- | |
| Yes, I know what you think: there are already a ton of MQTT related posts and videos circulating around the net. But here is one thing I noticed: most of them either failed to demonstrate how to get started with an MQTT broker, or did not show any code about how to actually get things working, or did not provide an easy enough concept to begin with. |
---
title: Knex ❤️ PSQL: updating timestamps like a pro
published: false
description:
tags: node, knex, psql, postgres
---
Knex.js is the most popular SQL query builder around and the go-to solution for most of us working with PostgreSQL. You can find dozens of articles even at dev.to about how to get started, so I decided to focus on a more advanced and often overlooked topic on how to keep the updated_at fields really updated - automatically.
| mkdir ~/vim | |
| cd ~/vim | |
| # Staically linked vim version compiled from https://github.com/ericpruitt/static-vim | |
| # Compiled on Jul 20 2017 | |
| curl 'https://s3.amazonaws.com/bengoa/vim-static.tar.gz' | tar -xz | |
| export VIMRUNTIME="$HOME/vim/runtime" | |
| export PATH="$HOME/vim:$PATH" | |
| cd - |
| Sub Makró1() | |
| ' | |
| ' Makró1 Makró | |
| ' | |
| ' | |
| Dim dateCellValue As String | |
| Dim rowValue As String | |
| rowValue = 6 | |
| { | |
| "_id" : ObjectId("575e65475dd724c737ce021c"), | |
| "name" : "Giga template mocsok sok blokkal", | |
| "customer_id" : 110392203, | |
| "blocks" : [ | |
| { | |
| "template" : ObjectId("575e6556e305ed7bf0000001"), | |
| "_id" : ObjectId("575e66355dd724c737ce0223") | |
| }, | |
| { |
| <!DOCTYPE html> | |
| <html> | |
| <head> | |
| <meta charset="utf-8"> | |
| <meta name="viewport" content="width=device-width"> | |
| <title>JS Bin</title> | |
| </head> | |
| <body> | |
| <script id="jsbin-javascript"> |
| '.source.js.jsx': | |
| 'Component class': | |
| 'prefix': 'comp' | |
| 'body': """ | |
| export class ${1:SampleComponent} { | |
| constuctor() { | |
| } | |
| static create() { |