Suoritettu

Create a Data Studio Community Connector

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!

Taidot: JavaScript, BigQuery, Google Cloud Platform

Näytä lisää: create data entry form visual studio 2010, create data entry forms visual studio 2012, create data entry form visual studio, google data studio api connector, google data studio community connectors, facebook data studio connector, google data studio connector tutorial, google data studio community, google data studio facebook connector, data studio facebook connector, create data studio connector, data studio custom connector, google data studio connector development, community visualizations data studio, google data studio community visualizations, data studio community visualizations gallery, data studio community visualizations funnel, data studio community visualizations library, data studio community visualizations, google data studio json connector

Tietoa työnantajasta:
( 4 arvostelua ) Wallisellen, Switzerland

Projektin tunnus: #31848809

Myönnetty käyttäjälle:

(1 arvostelu)
1.2

11 freelanceria on tarjonnut keskimäärin $179 tähän työhön

Friends4it

We have built several eCommerce stores like [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] Lisää

$250 USD 5 päivässä
(36 arvostelua)
6.1
artocenter

Hi. I am an expert engineer with 8+ years experience in BigQuery, Google Cloud Platform and JavaScript. A skilled developer, able to learn and adapt quickly to new technologies. I've checked the job descriptions. You c Lisää

$100 USD 2 päivässä
(8 arvostelua)
4.7
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 Lisää

$250 USD 2 päivässä
(10 arvostelua)
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 Lisää

$200 USD 7 päivässä
(3 arvostelua)
2.7
(5 arvostelua)
2.1
Work12345x

Hi, I am a very talented software programmer with 12+ years of development experience (4+ years professional work experience). I am a results-oriented professional and possess experience using cutting-edge development Lisää

$60 USD 3 päivässä
(4 arvostelua)
1.9
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 Lisää

$130 USD 7 päivässä
(1 arvostelu)
1.4
sanjaykhatri

Hello! **I am a professional PHP Developer, Start immediately! ** I am Sanjay khatri a Certified Web Developer with 10 years of development experience. I have strong skills in HTML, HTML5, CSS3, Bootstrap, JAVASCRIPT, Lisää

$210 USD 7 päivässä
(2 arvostelua)
1.5
abbassdamani

Hey! I've gone through project description and got that you are looking for website developer for your project, I have 7+ years of experience in website design and development and I have done a lot of projects like th Lisää

$200 USD 5 päivässä
(0 arvostelua)
0.0
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 Lisää

$210 USD 4 päivässä
(0 arvostelua)
0.0