Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

add the sample data to load for faster evaluating #131

Open
itsmesrds opened this issue Sep 3, 2021 · 2 comments
Open

add the sample data to load for faster evaluating #131

itsmesrds opened this issue Sep 3, 2021 · 2 comments
Assignees
Labels

Comments

@itsmesrds
Copy link

Its actually good to hav the sample data set used in the demo in repo or somewhere.

@sachinkbansal sachinkbansal added this to the v0.4 milestone Sep 17, 2021
@sachinkbansal
Copy link
Contributor

sachinkbansal commented Sep 18, 2021

@sachinkbansal sachinkbansal assigned vincue and sachinkbansal and unassigned vincue Sep 20, 2021
@sachinkbansal
Copy link
Contributor

BIgQuery sample query with public dataset

SELECT
date_add(PARSE_DATE('%Y%m%d', date), interval DATE_DIFF(CURRENT_DATE(), '2017-08-01',DAY) DAY) as dt,
geoNetwork.country, trafficSource.source,
SUM(totals.visits) AS visits,
SUM(totals.pageviews) AS pageviews
FROM `bigquery-public-data.google_analytics_sample.ga_sessions_*`
WHERE
_TABLE_SUFFIX BETWEEN '20160801' AND '20170731'
GROUP BY 1, 2, 3
ORDER BY 1

@sachinkbansal sachinkbansal removed this from the v0.4 milestone Oct 13, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

4 participants