To GoodData homepage

Topics started by Patrik Braborec

9 Topics

Patrik Braborec
GoodData Employee
Patrik BraborecGoodData Employee
published in Data sources

How To Analyze CSV DataTutorial

If you have data in CSV format and want to analyze it, this short article provides a step-by-step guide on how to achieve such analytics.Check open-sourced repository gooddata-csv-analytics.PrerequisitesGoodData account (if you do not have one, you can register your free trial) Installed dbt Core (you can find installation guide in dbt documentation)Step 1: Add CSV to dbt seeds folderIf you use the open-source repository gooddata-csv-analytics, go to the import_csv folder, where you can place your CSV files.dbt comes with an inbuilt csv loader (seeds) to populate your data warehouse with any files you put inside of your project’s seeds folder.Step 2: Edit profiles.ymlThe profiles.yml must contain connection details for your data warehouse (i.e. PostgreSQL). You can find profiles.yml on the following path:$ ~/.dbt/profiles.ymlYou can open it with Visual Studio Code:$ code ~/.dbt/profiles.ymlNow, you can edit your connection details and save them:import_csv: outputs: prod: type:

5030
Patrik Braborec
GoodData Employee
7 months ago
Patrik Braborec
GoodData Employee
Patrik BraborecGoodData Employee
published in Dashboards and Reports

How To Create Alerts in GoodDataTutorial

If you wish to set alerts for specific metrics or visualizations in GoodData, this tutorial will guide you through the process of using the GoodData Python SDK. Alerts enhance your monitoring capabilities for critical metrics and automate the notification process, which can assist you in preventing serious issues. With the flexibility of the GoodData Python SDK, you aren't limited to just one predefined solution, so you can customize it to your heart's content.You can check the whole repository here.Prerequisites:GoodData Cloud and GoodData API token S3 bucket SMTP server to send emails (for example, Gmail) What Is Gmail SMTP and How to Use Gmail With My Domain? We reccomend you to use Python virtual environmentYou can still create alerts without an S3 bucket, but your capabilities will be limited. This is because the S3 bucket is used to store information about notifications that have already been sent. Without it, you will receive the same notification repeatedly.Disclaimer:It works

1820
Patrik Braborec
GoodData Employee
7 months ago
Patrik Braborec
GoodData Employee
Patrik BraborecGoodData Employee
published in GoodData.UI

GoodData with Next.jsTutorial

Next.js is a popular framework for building web applications. If you've built a web application using Next.js, the following text will show you how to integrate GoodData into it.Step 1: Install all necessary dependenciesThe following packages deal with GoodData backend:npm i @gooddata/api-client-tiger @gooddata/sdk-backend-tigerThe following package contains all components of GoodData UI SDK:npm i @gooddata/sdk-ui-allTip: If you do not need to install all components, you can select only those you need. More info is in the documentation.The following package will help you generate a file with code representation of all available metrics and attributes in your GoodData Cloud:npm i -D @gooddata/catalog-exportStep 2: Extend package.jsonYou need to modify package.json, and add the following properties:"gooddata": { "hostname": "<your-gooddata-host>", "workspaceId": "<your-workspace-id>", "catalogOutput": "app/gooddata-export.ts", "backend": "tiger"}The configuration

1400
Patrik Braborec
GoodData Employee
8 months ago
Patrik Braborec
GoodData Employee
Patrik BraborecGoodData Employee
published in Dashboards and Reports

Scheduled export of visualizations and dashboardsTutorial

If you want to export your dashboard data on a regular basis, you can do it by utilizing GoodData Python SDK. Disclaimer: the code below uses the development release of GoodData Python SDK. You can install the development release of GoodData Python SDK by executing the following command:pip install gooddata-sdk==1.3.1.dev4 CSV or XLSX ExportYou can use tabular export in case you want to use data in CSV, or XLSX format of particular visualization. The following code block shows how you can do it via GoodData Python SDK.from gooddata_sdk import GoodDataSdk, ExportRequest# GoodData base URL, e.g. "https://www.example.com"host = "https://www.example.com"token = "<your_personal_access_token>"sdk = GoodDataSdk.create(host, token)# Export a particular insight in the desired format (CSV / XLSX)sdk.export.export_tabular_by_insight_id( workspace_id = "demo", insight_id = "revenue", file_format = "CSV", # The flag use_labels ensures that names of columns are according to your

2270
Patrik Braborec
GoodData Employee
10 months ago
Patrik Braborec
GoodData Employee
Patrik BraborecGoodData Employee
published in Data models - KB articles

Simplified declarative API In GoodData.CN 2.0Tutorial

Hi Community, let us inform our users, mainly those who manage the data model via API, that we in GoodData simplified declarative API In GoodData.CN 2.0. It is no longer necessary to create a “primary label” definition. By design, primary labels will be automatically available in attributes of an entity API (with the same ID). If you are not using our Logical Data Model (LDM) modeler UI but manage your model manually via API, please ensure that your primary labels and attributes have the same ID. Otherwise, you may find that your dashboard will stop working with messages like:{...,"status":400,"detail":"An error has occurred during the calculation of the result","resultId":"b61422c23443","reason":"Cannot find label with id='label/label.gooddata.name/28cdfs43dw221134' in LDM”,...}Steps to avoid the mentioned problemGET /api/v1/entities/workspaces/<id>/labels?filter=primary==true&include=attribute - this will list you all primary labels and attributes. You will get similar resp

370
Patrik Braborec
GoodData Employee
1 year ago
Patrik Braborec
GoodData Employee
Patrik BraborecGoodData Employee
published in SDKs and APIs - KB articles

Import GoodData OpenAPI schema to Postman API PlatformTutorial

It is heavily recommended to use the Postman API Platform for communication with GoodData API (of course if you do now want to communicate with GoodData API directly from code). In this post, I will explain how to import GoodData Open API schema to the Postman API Platform.PrerequisiteYou should have installed Postman API Platform on your computer. Step 1: Copy GoodData Open API schema URLhttps://www.gooddata.com/developers/cloud-native/doc/hosted/api-and-sdk/api/gooddata-cn-oapi-all-raw-schema.jsonStep 2: Open Postman API Platform and import GoodData API schemaClick the Import button in the left top corner:Click the Link tab and paste there the URL from the Step 1 and click the Continue button:Show advanced settings be sure that Folder organization is set to Tags:Click the Import button:GoodData Open API schema is successfully imported! 🎉🎉🎉Step 3: Set up API Token and GoodData URLOpen OpenAPI definition and click the Authorization tab:Select the Bearer Token:Put your API Token to t

4810
Patrik Braborec
GoodData Employee
1 year ago
Patrik Braborec
GoodData Employee
Patrik BraborecGoodData Employee
published in Administration

Embed dashboard with a silent login via Auth0Tutorial

This article extends the article Embed dashboard with a silent login via Okta SSO. We will show you how to embed GoodData.CN Dashboard to custom React.js application with a silent login via Auth0. Before we dive into the problem, let me just say that I am running GoodData.CN and React.js application on my computer — therefore, all API requests are to localhost.Step 1: Create Auth0 Application for GoodData.CNFor successful SSO, we need to create a new application in the Auth0 manage section.Select Applications in the left panel.   Click the Create Application button and select Regular Web Application.   Fill up Allowed Callback URLs, Allowed Web Origins, and Allowed Origins (CORS).   For the Allowed Callback URLs it is important to fill up the correct URL https://<organization-hostname>/login/oauth2/code/<organization-hostname>. In our case, where we run GoodData.CN locally, the URL is http:/localhost:3000/login/oauth2/code/localhost. For the rest (allowed web origins and

8811
JeffC
1 year ago
Patrik Braborec
GoodData Employee
Patrik BraborecGoodData Employee
published in Administration - KB articles

Embed dashboard with a silent login via Okta SSOTutorial

This article is a follow-up to the article Okta SSO Integration Guide with GoodData.CN. We will show you how to embed GoodData.CN Dashboard to custom React.js application with a silent login via SSO. In the first article, we ended up with the OpenID Connect (OIDC) configuration. OIDC is an OIDF standard that profiles and extends OAuth 2.0 to add an Identity Layer — creating a single framework to provide secured access to APIs, mobile native applications, and browser applications in a single, cohesive architecture. Before we dive into the problem, let me just say that I am running GoodData.CN and React.js application on my computer — therefore, all API requests are to localhost.Step 1: Map Okta user-to-user in GoodData.CNLet’s map the Okta user to GoodData.CN with two simple API calls. The first one updates the OIDC settings of the organization: $ curl --request PUT \  --header "Authorization: Bearer $GDC_API_TOKEN" \  --header 'Content-Type: application/vnd.gooddata.api+json' \  --data

6550
Patrik Braborec
GoodData Employee
2 years ago
Patrik Braborec
GoodData Employee
Patrik BraborecGoodData Employee
posted in About GoodData

Build a Tool for Data Analysis

I recently wrote two articles about GoodData.CN where I am demonstrating how to use it with a real use-case. In the first article, you will learn how to connect GoodData.CN to your PostgreSQL database and how to scan that database in GoodData.CN. The second article is about data visualizations and embedding them into a web application.The first part is available here: Build a Tool for Data Analysis — Connect Data.The second part is available here: Build a Tool for Data Analysis — Data Visualizations.

0
Patrik Braborec
GoodData Employee
2 years ago
Welcome to the GoodData Community!Cookie settings