Create a Data Studio Community Connector

Completed Posted 2 years ago Paid on delivery
Completed Paid on delivery

create a Data Studio Community connector for BigQuery:

[login to view URL]

IMPORTANT TO UNDERSTAND: the goal of the project is to create ONE report which will give access to different BIGQUERY DATASETS depending on the E-MAIL ADDRESS of the person VIEWING the report. So we can use the same report and simply control which e-mail address should see which data.

it should use the Advanced Services : [login to view URL]

It should work very similarly to the standard BigQuery connector, but the user should not select a BigQuery Dataset, instead it should select a DataSet type

then the name of the table can be simply selected from a list provided per DataSet type.

The idea, is that the system must identify the right dataset based on the identification of the Report Viewer E-mail : [login to view URL]

Based on the e-mail address, the system will retrieve the DataSets, by accessing a BigQuery view.

So for example, if the user has the e-mail address "abc at [login to view URL]", then there must be a BigQuery view which can be called and which will return, for this e-mail address what are the datasets this user has access to (e.g. "accountA", "accountB", "accountC".

Then, the system can take the name of the table configured in the data source.

The resulting bigquery select will then be like this (considering the dataset type is "reports", the project is "projectY", and the table is "tableX" :

SELECT *, 'accountA' as eshop FROM [login to view URL]

UNION ALL

SELECT *, 'accountB' as eshop FROM [login to view URL]

UNION ALL

SELECT *, 'accountC' as eshop FROM [login to view URL]

As you can see, the result will be that (in case the user has access to several dataset) each dataset will be accessed with a UNION ALL between the queries and the name of the dataset will be added as a field (eshop).

Otherwise, the Connector should work exactly the same way as the standard BigQuery Connector.

The UI should be done in a way which is simple to configure where the user can simply select one of the possible dataset types ("reports", "views", "lab", "core") and select a table name (another BigQuery view should be created to provide a list of possible tables per dataset type).

IMPORTANT: IF THERE ARE SEVERAL SOURCES IN THE SAME REPORT, WE NEED TO MAKE SURE THE AGREEEMENT OF THE VIEWER TO ACCESS THE EMAIL ADDRESS IS ONLY ASKED ONCE FOR THE ENTIRE REPORT!

JavaScript BigQuery Google Cloud Platform

Project ID: #31848809

About the project

11 proposals Remote project Active 2 years ago

Awarded to:

(1 Review)
1.2

11 freelancers are bidding on average $179 for this job

Devrits

Hi Hiring manager I am Data Scientist/DataOps with GCP/AWS and ETL expertise I am a 8 years experience Data sciense/analytics. I'm able build data pipelines on any cloud platform or even on promise. Experienced Pytho More

$250 USD in 2 days
(10 Reviews)
5.3
milanpesicf

MILAN-PERFECTION I am a full stack developer WHO ALWAYS BRINGS THE HIGH QUALITY in time. A talented and skillful developer who is the master of such jobs with rich experience. You job description certainly dragged my e More

$200 USD in 7 days
(3 Reviews)
2.7
karimdeveloper41

Hello, your project is very interesting for me I just checked your project description carefully. Now i feel this project is just matching for my experience and skill very well. Thanks to make me happy to face project More

$130 USD in 7 days
(1 Review)
1.4
devroma

Hi, Dear I`ve read your project post very carefully and I`m really interest in your project. I`ve rich 6+years of experience and knowledge in this field. If you hire me, I can start right now and I`ll provide you wit More

$210 USD in 4 days
(0 Reviews)
0.0