"If, according to law, the services provided by us to you pursuant to this Agreement are at any time found to be exempt from VAT, then we will credit the VAT charged to you and collected by us. In addition, in such event, the membership fee charged to you will be retroactively increased by an amount equal to the VAT amount that is to be credited to you. Such credits and accompanying membership fee increase will offset each other and the total amount paid to us by you will remain the same."
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
CREATE VIEW EFEKTIVITA_TRASOVANI AS | |
SELECT | |
RECORD_CREATED::DATE AS CREATED, | |
replace(split_part(QUEUE_NAME,']',1),'[','') AS KHS, | |
RECORD_ID AS POZITIVNI, | |
KONTAKT AS KONTAKT | |
FROM "CAMPAIGN_RECORDS_PII" | |
LEFT JOIN ( | |
SELECT | |
REPLACE(REPLACE(FK_RECORD_ID,'["',''),'"]','') AS "POZITIVNI", |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SELECT | |
shop, | |
date, | |
itemId, | |
itemName, | |
itemUrl, | |
currentPrice | |
FROM | |
`hlidacshopu.hlidacshopu.allshops_uniq` | |
WHERE |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
[ | |
{ | |
"count_all": "16509", | |
"count_bf": "", | |
"declared_sale": "", | |
"key": "rohlik", | |
"percent_bf": "", | |
"real_sale": "" | |
}, | |
{ |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
import subprocess | |
import sys | |
import json | |
subprocess.call([sys.executable, '-m', 'pip', 'install', 'git+https://github.com/keboola/sapi-python-client.git']) | |
from kbcstorage.base import Endpoint | |
sourceEndpoint = Endpoint('https://connection.keboola.com', 'components', 'xxx-yyyy-zzzzz') | |
destinationEndpoint = Endpoint('https://connection.keboola.com', 'components', 'aaa-bbbb-ccccc') |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
{ | |
"latitude": 37.8267, | |
"longitude": -122.423, | |
"timezone": "America/Los_Angeles", | |
"currently": { | |
"time": 1558117094, | |
"summary": "Mostly Cloudy", | |
"icon": "partly-cloudy-day", | |
"nearestStormDistance": 5, | |
"nearestStormBearing": 211, |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SELECT TABS.TABLE_NAME , | |
TABS.TABLESPACE_NAME , | |
TABS.OWNER , | |
TABS.NUM_ROWS , | |
COLS.COLUMN_NAME , | |
COLS.DATA_LENGTH , | |
COLS.DATA_PRECISION , | |
COLS.DATA_SCALE , | |
COLS.COLUMN_ID , | |
COLS.DATA_TYPE , |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
ssh-rsa AAAAB3NzaC1yc2EAAAADAQABAAACAQDhvEcRs/sW1LKPCW2/nVx/xs2yUAe5QegP0jaqrEEbhAgXnqKBh1IIIOeEPY0NLT4iMT6jxAoKaHvpWr9nlcI4azRnk8wXLQhwlLnSPZpX0OnmvoOyg3tzWSesf7DN9O0/ecmOpC1JxI3j/yWDPU2aKLLM+sPsuRZd8XwB+DvKPQkSAb58pe1WYOIgchIOrf0SZ6pyVP4g3wR0R0YEvsaFExR4WccpOKYjDKhYsDFtoZL7tkuFD5ESzZ44bPNP2pREUqA9hi7OfDY757Vq3jNuDUEdrxQ/AYs711b7jXuLjBTdoEweGapW6qU8fk+lnQMgj2PfUBGxIYfV8NVDPC/kihtNAd2uiF31M7D0fBW6vyDdEzCE3Lcw4Fgff85ZAxHh/DGCLZuWRUuqzFwrawj/wxDYe5x+T89Kq/sJ3J3FThIDk2HksEnGSvbznVWW8FLhaAKsuq5aSLvN8pXq4/HFDapOmmTznkgKk7uA6qXN+97Xkx8wJJofE8oyCh8RW5S1bkzkELF548Ca/m2aFRZ7uOtZ5EMyTqnyo4bFj3qiD1sp0uzjaCQufQR7ei5MYCe+WsyjH3S2CvH7NhvD0j1K9lI1aC8N8erx7igE4hwLH6yXB1/KwvjGG8siTLS2kJwxw+OIe0TbdwHUbo0AXT/F4PHVMeP16onTL7QOGRiBMQ== cardno:000608603345 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/* X days as a WHERE filter */ | |
SET back = to_char(TIMEADD("hours", -240, CURRENT_DATE ()),'yyyy-mm-dd'); | |
/* in this case, DATE_COL has `2017-08-10 13:05:20.395000` format */ | |
CREATE TABLE "data_10days" AS | |
SELECT | |
* | |
FROM "big_table" | |
WHERE "DATE_COL" >= $back; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
S3 | |
Lambda | |
Data Transfer | |
RDS | |
EC2 | |
DynamoDB | |
ECR | |
API gw | |
R53 | |
Config |
NewerOlder