I can retrieve all datasets and tables from Bigquery but when trying to actually get the data (preview or executing custom sql). It happens for Live connection and Elasticube.I use a json service account file to authenticate and withing Google Cloud ...
All of a sudden, all the name type fields/columns are now returned as { "Name": "John Doe") instead of John Doe. Data source is all from Salesforce tables. Is this a connector issue? It was ok before today. Thanks.
Hi to all.I am a brand new Sisense user, never used before, and sorry if this question is too basic.I am trying to connect to our BigQuery database and I was reading that I need to copy as service account, therefore I will need the key .json file and...
I am using the Accordion plugin and it works great. My only issue is that it places a symbol with a hover over in widget title. Great idea but it causes the widget title to look garbled and hard to read. I would like to remove this in the widget titl...
Hi there ,We've had a table called jora.historical_email_engagement that was connected to Sisense Periscope yet stopped updating the data from 28th June onwards.The original table source is updated regularly and can be queried via SQL workbench. Howe...
Has anyone used SingleStore as a basis for a Live Model? We are experimenting with it but are running into some issues with date or date/time fields and I was wondering if anyone else encountered similar issues.
Hi there, We have a problem with a dashboard which is showing incorrect summary data. We have validated that running the query on the raw data gives the correct results but for some unknown reason, Sisense appears not to be loading all the rows from ...
Hi All,Currently I am using the followingkubectl cp /home/ftpifx sisense/`kubectl -n sisense get po -l 'app=management' | awk 'END { print $1 }'`:/opt/sisense/storage/data/informix/command to copy files between our local system and the storage pod.Ho...
Our dashboard users have a specific request; they want to see data within a particular time period Below is how my dataset looks like (dates are mm/dd/yy). User request - To see how many customers were subscribed within a time period regardless of th...
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...
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...
Where do you prefer to perform data transformations and why? Should it be done in a data warehouse, or is it best fit for a BI tool? I have a preferred answer, but I'm really interested to hear what customers and experts have to say!
