Resolved! live cubes - databricks
the sisense native databricks connector works with live cubes, currently it works with elastic cubes but when I try to create a live cube but the databricks option does not come up.
Forum Posts
Is it possible to create a custom Python connector?
I was wondering if there's a way to create additional connectors using Python? We are able to create custom code Python scripts that can for example retrieve data from an API. This works great, but using the custom code approach has some problems: 1....
Resolved! mongo connector
I need to create a cube with the mongo connector but when I go to create the connection I do not see the connector, I go and enable it from the configuration and go back to add the source and still the connector does not appear, what additional step ...
JDBC connector for live model
Hi, We had established Athena connection using the JDBC connector present under elasticube model. We wanted to establish Athena connection using live model but could not find JDBC connector for the same. Do let us know the right way to connect with A...
Error when trying to connect my RDS MySQL Server Instance
Suddenly, I started to get No such host is known when trying to refresh and connect my RDS MySQL Server Instance.
Loading ElastiCube from s3
We will have our data files, one per day residing in S3. We would like to load these files into Sisense Elasticube. From the Sisense website, it appears that there should be an S3 connector, but the link goes to a generic page. See the link at the bo...
Using a dashboard multi-tenant?
We are using Sisense to provide dashboards to our clients. In order to keep the security relatively simple, the idea is that each client would have their own cube/live data source. All sources will have the same schema. The idea is that we could desi...
REST API v2 Dataset Bigquery
Hi! I have been trying to get familiar with the REST Api and managed to connect & create a datamodel through a Python script. Now for the next step I would like to create a dataset in this datamodel by connecting to BigQuery, I only can not seem to f...
Resolved! how to configure the connection in databricks by means of api
I want to create dynamic connections for databricks by means of the api, but from sisense it shows me that I don't have access to create connections neither to modify, apparently for being using linux with windows if it exposes these methods, making ...
Resolved! How to change a Live connection settings?
Hi, I'm not able to change the Live connections settings. I have changed the password in my Snowflake but I'm not able to change the credentials in the Sisense Live connection. Any idea? BR
Issue in Flattening JSON objects in Jira
We actually have to flatten the column which has JSON kind of representing data in the sisense elastic cube which was imported from Jira data source through JDBC connector. For this we have tried the JSON_Value() to split JSON consisting column to fl...
Google Sheets Connector Elasticube Build Error - Failed to read row - need help!
When using a Google Sheets connector in an Elasticube model, we are receiving a build error that doesn't make sense due to the data in it. Error: Build failed: base table "google_sheet" was not completed as expected.Failed to read row: 0, Connector (...
Resolved! Continuous Deployment on Live Data Models
Hello Folks, How do you migrate a development data model that reads data from a Development Schema to a production data model that reads data from a Production Schema without actually creating the data model from scratch? Details: We're about to make...
Resolved! Matching charts with different level of number
Good day fellow members, I have a quick question. So here are temperture data (e.g. 11.5 celicius) and the number of cases (e.g.50k) and I want to correlate them in a same graph. However since the measure level is different the temperature bar went r...
Resolved! Year cannot be recognized
Hi! I just started using Sisense and so shame that it's such a basic problem, but I cannot seem to visualize the following columns about the year and number of crimes in Japan. when I visualize it, the year only shows as 1905? (see attached) Year 合計(...
