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 tableauserverclient as TSC | |
import os | |
import argparse | |
import logging | |
# set up logging | |
logging.basicConfig(level=logging.INFO, format='%(asctime)s %(levelname)s %(message)s', filename='tableau2csv.log') | |
logger = logging.getLogger(__name__) | |
# set up argument parser |
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
{"ts":"2022-10-31T10:01:05.860823","pid":40503,"tid":"318df1000","sev":"info","req":"3","sess":"pd29g2fASvK9yikO2lCjDA","ctx":{"req":"-","site":"-","user":"-","host":"Eddie","workload":"interactive"},"k":"query-begin","v":{"spooling":false,"query-settings-active":false,"query-hash":"025a.3898559fb452.000000","query":"CREATE DATABASE \"/Volumes/T7/tmp/knmi_daggegevens_daggegevens+ (agrajag).hyper\""}} | |
{"ts":"2022-10-31T10:01:05.860971","pid":40503,"tid":"31433a000","sev":"info","req":"3","sess":"pd29g2fASvK9yikO2lCjDA","k":"query-running","v":{"worker-slot":7}} | |
{"ts":"2022-10-31T10:01:05.861527","pid":40503,"tid":"31433a000","sev":"info","req":"-","sess":"-","k":"transient-resource-create","v":{"storage-id":{"provider":"transient","path":"sessionDB_pd29g2fASvK9yikO2lCjDA"},"elapsed-create-tempfile":0.00021175,"temp-path":"/private/var/folders/cp/3kpxz2ws6jd1lsy3p6t_k72m0000gn/T/tableau-temp/hyper_40490_1tn72ho12n7n671fqgodt0exsbon/hyper_transient.40503.1.tmp","elapsed-do-create":0.000157125,"elapsed":0.0003709 |
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
<div class='tableauPlaceholder' id='viz1664378640267' style='position: relative'><noscript><a href='#'><img alt='view ' src='https://public.tableau.com/static/images/AC/ACLEDrangeselector/view/1_rss.png' style='border: none' /></a></noscript><object class='tableauViz' style='display:none;'><param name='host_url' value='https%3A%2F%2Fpublic.tableau.com%2F' /> <param name='embed_code_version' value='3' /> <param name='site_root' value='' /><param name='name' value='ACLEDrangeselector/view' /><param name='tabs' value='no' /><param name='toolbar' value='yes' /><param name='static_image' value='https://public.tableau.com/static/images/AC/ACLEDrangeselector/view/1.png' /> <param name='animate_transition' value='yes' /><param name='display_static_image' value='yes' /><param name='display_spinner' value='yes' /><param name='display_overlay' value='yes' /><param name='display_count' value='yes' /><param name='language' value='en-US' /><param name='fi |
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
<html lang="en"> | |
<head> | |
<script type="module" src="https://public.tableau.com/javascripts/api/tableau.embedding.3.latest.min.js"></script> | |
<title></title> | |
</head> | |
<body> | |
<button onclick="filterState()">filter</button> | |
<button onclick="clearState()">clear</button> | |
<button onclick="unDo()">undo</button> |
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 tableauserverclient as TSC | |
import re | |
tableau_auth = TSC.PersonalAccessTokenAuth('TOKENNAME','TOKENVALUE') | |
server = TSC.Server('TABLEAUSERVER', use_server_version=True) | |
with server.auth.sign_in(tableau_auth): | |
for workbook in TSC.Pager(server.workbooks): |
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
CAST( | |
-- make collection | |
st_collect(ARRAY[ | |
-- make line from two range polygons | |
st_difference( CAST( | |
st_buffer( | |
CAST( | |
ST_MakePoint( | |
"postinfo"."lon", |
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
indicators = ['NY.GDP.MKTP.CD' # GDP (current US$) | |
'SP.POP.TOTL', # Population, total | |
'SE.PRM.ENRR', # School enrollment, primary (% gross) | |
'EN.ATM.CO2E.PC', # CO2 emissions (metric tons per capita) | |
'SI.POV.NAHC', # Poverty headcount ratio at national poverty lines (% of population) | |
'SP.DYN.LE00.IN', # Life expectancy at birth, total (years) | |
'SI.POV.NAHC', # Poverty headcount ratio at national poverty lines (% of population) | |
'NY.GNP.PCAP.CD', # GNI per capita, Atlas method (current US$) | |
'IQ.SCI.OVRL', # Statistical Capacity score (Overall average) | |
'SI.POV.URHC', # Urban poverty headcount ratio at national poverty lines (% of urban population) |
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 | |
'CyberSecurityIndex' AS "index", | |
"CyberSecurityIndex"."Country" AS "Country", | |
"CyberSecurityIndex"."iso3" AS "iso3", | |
CAST("CyberSecurityIndex"."Year" AS TEXT) AS "Year", | |
t.subindex AS subindex, | |
CAST(t.value AS float) AS value | |
FROM "indices"."009_cybersecurityindex" "CyberSecurityIndex" | |
cross join lateral ( | |
values |
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
@echo off | |
# Create date-timestamp to use in backup-filenames | |
for /f "delims=" %%a in ('wmic OS Get localdatetime ^| find "."') do set DateTime=%%a | |
set Yr=%DateTime:~0,4% | |
set Mon=%DateTime:~4,2% | |
set Day=%DateTime:~6,2% | |
set Hr=%DateTime:~8,2% | |
set Min=%DateTime:~10,2% | |
set Sec=%DateTime:~12,2% |
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
<!DOCTYPE html> | |
<html lang="en"> | |
<head> | |
<meta charset="UTF-8"> | |
<title>Title</title> | |
<script src="https://code.jquery.com/jquery-1.12.4.min.js"></script> | |
</head> | |
<body> | |
<script> |
NewerOlder