Questions tagged with Analytics
Content language: English
Select up to 5 tags to filter
Sort by most recent
Browse through the questions and answers listed below or filter and sort to narrow down your results.
I have a date like this '26 jun. 14:06:00', but i need only the time, how i can extrac only the time ?
1
answers
0
votes
272
views
asked a year agolg...
I'm researching on connecting PowerBI to RDS SQL Server SSAS.
PowerBI state that it needs the user to have Server Administrator Role...
1
answers
0
votes
283
views
asked a year agolg...
Hi,
In Athena, in the Console, I am getting a `HIVE_CURSOR_ERROR` when running:
(Queries, file paths etc. are anonymized)
```
SELECT DISTINCT file_path
FROM (
SELECT xid,
"$path" as...
2
answers
0
votes
366
views
asked a year agolg...
Calculating YTDlg...
Assume i have below dataset
Brand Date Revenue
Brand A 1/1/2023 30
Brand B 2/1/2023 50
Brand C 3/1/2023 60
I am trying to calculate YTD value which is Year to Date, on...
1
answers
0
votes
377
views
asked a year agolg...
I am using Data Quality to evaluate the dataset and I am routing the failed rules and failed records. But when i check the s3 bucket for the failed records i am seeing empty files along with the...
0
answers
0
votes
121
views
asked a year agolg...
Has anyone found a good way to parse tables that come back from Textract that are inverted? Specifically, getting the table name or column headers as they are not recognized via the API itself. Here...
0
answers
0
votes
81
views
asked a year agolg...
My Quicksight analysis data is failed to refresh multiple times now. Refresh was working fine till couple hours ago
0
answers
0
votes
78
views
asked a year agolg...
[ErrorCode: INTERNAL_ERROR_QUERY_ENGINE] Amazon Athena experienced an internal error while executing this query. Please contact AWS support for further assistance. You will not be charged for this...
1
answers
0
votes
243
views
asked a year agolg...
Hello,
I have a Glue Pyspark job that writes to Amazon S3 in a CSV format, I don't see any file with CSV extension on Amazon S3. How can see it ?
I am using `write_dynamic_frame.from_options`...
3
answers
0
votes
301
views
asked a year agolg...
Hey folks,
Please guide me with the link about the best ways to take a snapshot of EMR cluster without downtime.
Thank you
1
answers
0
votes
388
views
asked a year agolg...
Hi there,
I am wondering whether there is any proved way, to do data ETL from Azure SQL PaaS to Redshift. IHAC whose legacy system is running on the former and is trying to do the data analytics...
1
answers
0
votes
281
views
asked a year agolg...
Using the step: "Derived Column" where I can use SQL functions to derive new columns I found SUBSTRING works but CHARINDEX it doesn't. And as usual with AWS documentation, there's no place or...
1
answers
0
votes
381
views
asked a year agolg...