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.
We connected Timestream to Athena using the [Athena Timestream connector](https://docs.aws.amazon.com/athena/latest/ug/connectors-timestream.html). When running a federated query through Athena to...
2
answers
0
votes
759
views
asked 4 months agolg...
I am using a lambda to perform some transformation on records buffered into a kinesis stream.
This is my lambda (data is ingested in Gzip):
```
ef lambda_handler(event, context):
output = []
...
1
answers
0
votes
621
views
asked 4 months agolg...
I'm trying to achieve data change capture using AWS Glue and don't want to use DMS. I'm trying to transfer data between two Oracle RDS instances which are in different AWS Account. Here I am trying to...
1
answers
0
votes
474
views
asked 4 months agolg...
I'm trying to achieve data change capture using AWS Glue and don't want to use DMS. I'm trying to transfer data between two Oracle RDS instances which are in different AWS Account. Here I am trying to...
1
answers
0
votes
464
views
asked 4 months agolg...
Hello,
I have a MySQL custom query sourced dataset that includes a list of transactions with the following fields:
* branch - The branch the transaction occurred at
* sku - The item the transaction...
1
answers
0
votes
383
views
asked 4 months agolg...
I have a strange problem.
I created my first Visual ETL job; it runs fine, but there are a few mistakes in the output schema.
The problem is now when I try to open the job, it will not load in...
2
answers
0
votes
327
views
asked 4 months agolg...
Hello!
I am using Redshift Serverless and am having some difficulty with auto-complete. This understandably leads to tedious typing of queries and introduces unneeded typos.
We have several...
1
answers
0
votes
439
views
asked 4 months agolg...
This is a followup question to the post https://repost.aws/questions/QUzURnlUzOR9mfoQbiLwCNvA/incremental-data-capture-from-dynamodb-to-s3
With PITR feature in DDB, is it possible to incrementally...
1
answers
0
votes
509
views
asked 4 months agolg...
Using SQL Alchemy ORM to query an AWS athena database. First off, here is the raw SQL query, which is working perfectly
```sql
WITH zi AS (SELECT
trip.start_dt,
address.zone_id
FROM...
1
answers
0
votes
455
views
asked 5 months agolg...
Hi all, I am trying to implement lake formation security on my data lake consisting of bronze, silver, gold zones in s3 and glue catalog tables. The gold zone data also exists in redshift tables with...
1
answers
0
votes
366
views
asked 5 months agolg...
Hi all, I had a quick question regarding AWS Glue Catalog Tables.
I currently have a crawler that is crawling one folder with 3 files of the same schema. If I want to reduce to just 1 file, would I...
1
answers
0
votes
355
views
asked 5 months agolg...
Hi all, I need to demonstrate lake formation data filters usage. What is the easiest way to query this data and show the difference caused by filters.
I have 2 roles accessible to my account. One role...
1
answers
0
votes
300
views
asked 5 months agolg...