Have what I think is a fairly simple SQL query but taking forever when pulling an extract into Tableau or Alteryx. Anyone down to take a look at it and see what I'm doing wrong or how I can fine tune?

Posting as :
works at
You are currently posting as works at

SELECT
A.TRANS_MSTR_KEY,
A.DT_SKEY,
A.TM_SKEY,
A.STORE_KEY,
A.TRANS_NBR,
A.CUST_KEY,
A.TRANS_TYP_KEY,
A.SALE_AMT,
B.TRANS_LNK_KEY,
B.PRODUCT_KEY,
C.STORE_ID,
C.CITY_NM,
C.POSTAL_CD,
C.STATE_NM,
D.PRDCT_DESC,
D.PRDCT_CD,
D.DEPT_NM,
E.TRANS_TYP_ID,
F.SUBSCRIBER_ID,
F.EM_DT
FROM "xxxx"."xxxx"."TableName"A

LEFT OUTER JOIN "xxxx"."xxxx"."TableName"B
ON A.TRANS_MSTR_KEY = B.TRANS_MSTR_KEY

LEFT OUTER JOIN "xxxx"."xxxx"."TableName"C
ON A.STORE_KEY = C.STORE_KEY

LEFT OUTER JOIN "xxxx"."xxxx"."TableName"D
ON B.PRODUCT_KEY = D.PRODUCT_KEY

LEFT OUTER JOIN "xxxx"."xxxx"."TableName"E
ON A.TRANS_TYP_KEY = E.TRANS_TYP_KEY

LEFT OUTER JOIN "xxxx"."xxxx"."TableName"F
ON A.CUST_KEY = F.CUST_KEY

WHERE E.TRANS_TYP_ID IN ('01','02')

like

https://tinyurl.com/vrulv2x
You should've done this. Will help you a lot in your career

like

This isn’t going to work

like

Split up into smaller queries, otherwise use limit to run on subset and profile your code

Can you give an example of that. Fairly new to using SQL so not too sure how to execute this

???

Side question... would Domo be better to use for such large data?

Related Posts

Hi Guys,

Please Advice, TIA.

Post Photo
like
like

How does everyone track their daily and long term work to-dos (lists)? I am not the best at organising and feel overwhelmed with tracking and prioritising. Any tips?

like

What type of roles are consultants with functional transformation experience (process improvement / automation, analytics, performance management, operating mode design, etc.) exiting to? Feel like my quantitative skills aren’t in line with corporate strategy roles. Feeling like the only exit would be internal transformation/consulting group.

like
like

Hi guyz recently received offer from open text but when asked I told them that I have only 1 month notice period but actually I have 3 months notice period now ....I am bothered about loosing my offer if I say to open text requirement team about my notice period....any suggestion guyz

like

Hi can anyone please help me.
I have a big sql query with almost 9 joins in it. How can I convert these joins into dataframes for faster processing?

like

Okay, I feel like if a QE in India needs to email me, an SE, to just press the 'resolve' button on a user story that was created after a bug report was issued and fixed, then maybe... Just MAYBE... There might be a bureaucracy problem. 😒

likefunny

Dream job in learning posted in KPMG along with several other learning jobs. I am curious: why the growth? Can any KPMG fish speak to the (internal) learning team culture?

like

Hit me with the buzzwords you hate right now. I'm seeing "data visualization" so often in EVERYTHING I read that it's making my head spin.

like

RIA located in Hauppauge, NY is looking for an administrative assistant. Preference given to those with RIA experience. Let me know if you would like to have a conversation .

like

Does anyone have tips for the structured interview process? I’ve done my research but am not getting past the first round. My credentials must be acceptable if I’m being invited to interview at all. Since post-interview feedback isn’t provided, I’m sort of grasping at straws here!

What’s a good, practical tax book to read for someone who knows nothing about taxes? I feel like I should familiarize myself with them but don’t know where to start/find the topic very overwhelming and dense even as a finance attorney. Welcome to other beginning finance book suggestions too! (Already read Kiyosaki and Ramsey)

like

Love when the announcers say things like “3 of the top 10 have fallen” so dramatic and so spot on.

like

Potential client owns eCommerce site selling graphic design caricature posters of celebrities from independent artist submissions. Is there name & likeness issues with client selling the posters w/o celebrity approval?

Hey fishes,

I left my job without any new offer in hand. Will I be able to get a new job offer?

like

Currently on OPT and applying for H1b next year. Switching jobs and wondering if I need to get all my pay slips before I leave . Do I still have access after leaving the firm?

Looking for hotels near parel, Mumbai for a 4 day stay. Any reference

like

Currently privacy in-house counsel. Was offered senior privacy position at a tech company but it’s not a counsel role. Should I be concerned about future job options?

like

Does LTI have work tracking software installed on laptop ??

like

Additional Posts in Data & Analytics Consultants

What’s EY DnA tech stack? EY

likehelpful

Seems like all data scientists want to switch to PM. Is there a specific reason for this?

like

Hi all - I wanted to ask an odd question. I received an offer from a consulting firm for $120k as a senior consultant in Dallas. I have 5YOE all in data and analytics and this move would represent a large bump in my salary. My concern is that looking at the posts here it seems like the norm is $150k. Am I being low balled?

like

Hi all! Does anyone have any advice/resources on how to prep for business intelligence roles interviews? For example, data analytics/viz quesions (not necessarily coding on spot but explain how I would approach a data related request). So far I have been answering based on my work experience, but want to do a more systematic prep if possible

like

I am SICK and TIRED of these damn *nix symbolic links 🤬

like

It's an "enhanced workflow"

Post Photo
likefunny

Hi all, I have 2 YOE with Intel clearances and background in SQL, tableau, Salesforce, and azure. In the pipeline for a job at Microsoft but wanted to know salary range and opps at other companies. Thanks in advance

like

What’s the difference between a Staff DS and a DS?

like

What are the top sales & marketing metrics that tech companies track? I have an interview for a Data architect role and the data aspect is my strength but need to brush up on the business insight part

like

Anyone has insights on Homesite insurance? Got an interview and would appreciate the help!

Thoughts on Bain Advanced Analytics Group (AAG)? Can this career track lead to becoming a Partner?

like

Hey guys, got laid off yesterday for economic reasons so currently looking for referrals in data analytics/data science positions. Any help would be appreciated. Thank you!

like

Hey, does anyone have tips/insight into what I should expect from a Deloitte Analytics and Cognitive Case Study interview? (UK)

like

Does anyone use pipeline pilot for ETL on commercial production environments? Seems like very specific tech for scientific community

Why are you in data?

like

Any recommendations for ramping up my SQL skills (for free ideally but willing to pay for a course if worth it). No experience but looking to strengthen my analytics skillset

Anyone have references on market penetration of AutoML tools?

like

What's up with Data and Analytics roles with KPMG Technology Enablement Solutions? How is it different from Lighthouse.

Any cyber security folks here? or those interested in systems engineering? Potential role with TC 120-180, awesome team and wlb, at least compared to consulting.

like

Does anyone have any best practice metrics (e.g. customer service, SLA) for life insurance companies?

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Scan your QR code to download
Fishbowl app on your mobile

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal