Working at snowflake reddit. Never really heard about snowflake when I was in college so that also contributes to my skepticism. the underlying product being very reliable. The data is persisted in 'delta'/parquet format registered to the Databricks metastore so that the entire ETL pipeline is a thin layer of Python to retrieve the data from wherever, store it in the native schema in the bronze layer and then transform it with SQL through silver and gold and ultimately to end-user applications. Snowflake's mom's face started turning purple. 133K subscribers in the dataengineering community. Candidates applying for Intern had the quickest hiring process (on average 1 day), whereas Growth Engineer roles had the slowest hiring process (on average 360 days). Hi, I have recently tried snowflake in my new company after using spark for several years. Work life balance is highly team dependent. Come and take a look inside the life at Snowflake – our values, company culture, benefits, and more! . I don't care *that* much about engineer support vs. I’m the definition of a snowflake anti-fanboy, and I stand by my statement they are simply a Teradata, SAP, and now clearly an Oracle waiting to happen… Weird product, for companies with more money than sense. I am looking to get hired as a Solutions Architect at Snowflake. Hey everyone! I recently wrote a comprehensive blog post about the Snowflake SnowPro Core certification, and I'd like to provide a simplified version… Doh, Reddit formatting killed the calculation. This approach worked for me in mastering Excel and so far it is working well for Snowflake. Note that Amazon has a poor reputation for work life balance primarily due to being so heavily involved in the cloud. I work at Snowflake and can say that it would be a challenge to get into an AE role straight away. Salaries, reviews, and more - all posted by employees working at Snowflake. So any old company that wants to become data driven, whether this is a botoom up true transformation, or a top down decision, is going to investigate using Snowflake first, and that makes it highly likely for them to go with it. For what snowflake does well, there are no alternatives in today's market (maybe BigQuery?). But it was cheaper for us because all the load was quite bursty and hence snowflake is cheaper since you don’t waste time spinning up and down. Sep 6, 2024 · Snowflake has an overall rating of 4. clearly now they are trying to appeal to the Larry Ellison crowd who not only love wasting money on data solutions, but also a normal DE technical test (or conversation) is about a basic pipeline. Otherwise you can pick what you want. Snowflake is also simply the best data warehousing service on the market right now. Not nearly as cool as it should be in modern data world. 0 out of 5, based on over 810 reviews left anonymously by employees. For a role such as this: https://careers. Just because Snowflake is the biggest sw IPO ever does not change the expected payoff for non-execs/non-preferred stocks. In the example, you provided, star schema for sure. The cert training sucks. Snowflake is only necessary when you must reduce the size of your database and you see real space saving to do so. SAS is a software company with a few hundred SKUs/product combinations that range from statistics to BI to data science to marketing analytics to IoT to data engineering and everywhere in between. But then problems start there are massive bills, cost monitoring sucks, and Snowflake is this move fast and breaks things company so they are constantly pushing new features and old ones kinda stay half-baked mode for a very long time. Sep 12, 2024 · How long does it take to get hired at Snowflake? The hiring process at Snowflake takes an average of 29. Databricks is a platform with many things one being data warehouse (data lake) It depends on many factors, teams and work, who to pick. Databricks uses mostly open source software and utilizes cloud companies' compute and storage A good recruiter at a tech company should 100% know what Snowflake is. I started working with Snowflake in 2019, and they are by far the best performance database easily scalable up or down to control costs with a small configuration to increase or decrease the warehouse performance. As an example consider that you have to ingest 2 files: a parquet and a json file where both files are kind of related. All users in these AD groups are created/updated in Snowflake and users under these user roles are granted to them. Browse our open positions around the world and challenge yourself to rethink what's possible. I think it would be wise from a financial stance to talk to the advisor again but run it with two coming instead of one. Tor Metrics shows (download CSV file) that over the 15 days from June 15 to June 29, Tor had an estimated cumulative total of 4,014 Snowflake users. If each row is 1KB, it means 16000 records is the smallest unit of data processed as 1 block by the snowflake engine. Are you doing a lift and shift? Or move and improve? If the former, there are many ELT tools that you can point at existing tables and replicate the entire set into Snowflake. Browse Snowflake internship opportunities to work on cutting edge technology, learn from industry experts, and watch projects shape the future of Snowflake. It wasn't required, and she was ruining the trip for everyone. I've spent most of my career (10+ years) working within some context of Sql server (usually for analytics/data warehousing purposes). Snowflake is a data warehouse as core tech. You’d probably need to start as a SDR where you’d be dialing all day and maybe have a dotted line alignment to the broader sales org. The golden age to join Snowflake was between 2016 and 2019. As Snowflake is easy and cheap for volunteers to run, blocking all Snowflake proxies becomes a hard job. And works really well. In my limited experience with writing, let me try to make a productive reply. Back then the 4 co-founders, most who have PhDs in distributed systems, did the tech interviews. I think you are asking which company you should work for rather than which product to use, right? Snowflake is a subset of Databricks. Then divide that by 60 to get how many hours a week your warehouse is up (easier to work out billing by the hour). I use to work at emc and have some colleagues that went to snowflake and they all seem to love it (enterprise sales though). Many of our clients rush into using Snowflake thinking it’s the miracle database and realize later that the cost is high, that their DB is messy, security is not implemented well… Ok TLDR ON TOP BECAUSE I WAS NOT WELL INFORMEDApparently a full compendium of snowflake creators exist have a good day!. We manage two more tables in Snowflake for RBAC where we maintain one table level mapping to objects roles, means all tables in Snowflake should have an object role assigned like STG_GEN_LEDGER to FIN_SELECT, DM_SALES to SAL_SELECT. If the censor discovers and blocks the Snowflake proxy's IP, the censored user can request a new Snowflake and connect again to the Tor network. Being from Oracle background it feels easy for me to work with SQL/Plsql though. Generally the "famous" AWS teams like Aurora, Dynamo, EC2, IAM, etc will have terrible work life balance. Be careful what team you join. I'm kinda addicted to watching people grind harder/more difficult accounts while I grind my own. Some users depend on Snowflake to be able to connect. 0 out of 5, based on over 790 reviews left anonymously by employees. You can specify different warehouses (which are Snowflake's compute units) to run your operations on, and that's basically it as far as infra decisions go. Was this person likely embellishing their position or did they really hit the lottery starting working at Snowflake a measly 18 months ago? Literally all my friend from my business school and peers work at one of the 3 big tech companies (Amazon, FB, google, but especially Amazon in Seattle) so guess it’s partly the pressure from seeing my friends all work there as well. What are the features of Snowflake? Answer: Snowflake has the following features: I've not used Azure SQL but I use Snowflake at work. I’ve moved from spark + redshift - snowflake. My daughter was amazed at the special Snowflake's behavior. AWS, pay by usage with auto-suspend which some budget managers like, and many more make Snowflake imho the objectively best SQL Snowflake is the new hot thing for setting up a central data warehouse. I’m a huge Snowflake stan mostly since it just … works. Doh, Reddit formatting killed the calculation. Snowflake was designed from the ground up for the cloud. It gets more and more difficult to get promoted now and you most likely will be working for someone who succeeded in a much bigger territory with a much easier number to hit. Snowflake provides a centralized system to combine all the data in a place. A bit of background here. The Snowflake sale is extremely good, and you get something running pretty fast. I build XYZ using features ABC in Snowflake, let me tell you the tech I used", versus "I have a Snowflake cert and I build XYZ". Snowflake is cloud native so I’m not sure why you suggest it isn’t? Regardless, you can pick what you want for a cloud data warehouse. I wouldnt work for Databricks, but I'd work for Snowflake since theyre post IPO and not as plagued by Jira tickets. I'm also working on a book that is a multi-POV story, specifically coming from three different main characters. Snowflake creates micro-partitions, so you yourself are not required to manage how the data is stored. If you’re a MSFT shop, pick Azure. EPP means snowflake can scale well beyond 20 concurrent processes. If you understand how to apply cloud principles, Snowflake is also more manageable cost both for SMBs and at scale. Usually after attending a conference somewhere, he would be bursting with New Ideas. Having worked at startups myself, I find this highly unbelievable. Innovative features like the data marketplace, data sharing, separation of computing/storage, working across all clouds, near linear computing scalability, amazing documentation, modern sexy-looking UI compared to e. On May 31, 2023, Reddit announced they were raising the price to make calls to their API from being free to a level that will kill every third party app on Reddit, from Apollo to Reddit is Fun to Narwhal to BaconReader. The default warehouse auto-suspend time for a warehouse is 10 minutes (can be lowered), and as you’re running a task every 10 minutes, you’re running a warehouse essentially 24/7. Having been thru an IPO myself, I have seen how employees get their hopes up for a huge payoff, only to have that “meeting” about how your shares are now worth 5 % of what they were. As far as Snowflake vs Databricks, the biggest differences is that Snowflake stores their data in a proprietary format inside their own servers and uses their own servers for compute costs, so there isn't that provisioning stage that takes 5 minutes. . As a general rule, you should prefer star schema over snowflakes. I'm over working on Databricks til they stop logo chasing and focus on building relationships It's also super expensive if you consider the AWS costs along with their opaque DBU/hr charges. Here we are going to discuss the Snowflake sales engineer interview questions. About myself: I am 2 years out of college, generic corporate expe Daycare costs are insane so you also need to factor in whether or not one parent remains home after the degree is finished or if you both work and pay for care. This rating has been stable over the past 12 months. 300 mins multiplied by 7 days, for your minute total. Snowflake has the benefits of being on the cloud (configuring on local servers can be challenging), also the interface via SnowSQL (terminal) and the web UI is much better versus being dependent on something like dbeaver, additionally Snowflake makes importing/exporting data pretty simple, also Snowflake documentation > Vertica documentation, and their company is open to feedback if you're a . Space is so cheap these days, you are hard pressed to find examples where snowflake models are preferable. We haven’t looked back and Snowflake keeps coming up with ways to make our lives easier. g. It abstracts away a lot of the infrastructure and scaling concerns you have with a self-hosted DB. Join the team that's delivering the revolutionary AI Data Cloud. I am a rare data engineering bird that started on hadoop and spark and somehow ended up working at Snowflake with clients, so I'm definitely biased by my own experience and that of most clients, but if people want to boil this fight down to its essence of Snowflake v Databricks which we all tend to do, you have two options: You’re charged for warehouse uptime. You need to have a pretty good understanding of data warehousing concepts. News & discussion on Data Engineering topics, including but not limited… So, let me preface this by saying my earliest career experience involved working in SQL Server. It was built for one purpose and does it very well. I interviewed at Snowflake when they were about 30 people. You have a scripts to create tables, for example, and Snowflake determines what needs to be done to make the table match what's in the script. Working at a small-ish manufacturing company as the on-site IT person. I used to work at SAS, and I currently work at Snowflake. While I have struggled a bit to follow these steps simply because it's forcing me to be more detailed about my characters and story, I think i As u/frankbinette says - "customer success" at Snowflake is everyone's job. 77% of employees would recommend working at Snowflake to a friend and 80% have a positive outlook for the business. Reviews from Snowflake employees about Snowflake culture, salaries, benefits, work-life balance, management, job security, and more. Serious question We use Databricks with a cloud storage for our DW. A couple of things I’ve heard: you aren’t really selling products or services, you are selling snowflake tokens, which can then be used on the snowflake market place by customers to purchase products / services within I saw we have different type of languages which snowflake provided support for within its functions/procedures like sql, Java, python, scala, java scripts etc. My last two companies have used Snowflake and in the entire four-year period I've been working with it, I can only remember one 20-minute period where it was glitchy due to an AWS problem, so right there I would classify Snowflake as pretty reliable (but to be fair I It isn't really a new thing - Snowflake has been around since 2012 offering this service. ). Snowflake Career advice. In Snowflake's case, a censored user connects through a Snowflake proxy to the Tor network. So he would hire someone. Thanks very much for running the Snowflake addon extension. During the last two years I ended up working with a client who was using Snowflake and I came to love working with it (I'm in consulting fyi). Everyone is different, I guess. They all work great. The key is exporting the data into 250MB compressed chunks, pushing them to Snowflake, and then running a COPY command at scale to re-import the data. Per “effective” compute unit snowflake is 5x expensive compared to those options (redshift being roughly 2x spark?). Posted by u/super9090 - 4 votes and 7 comments Learn more about how we hire at Snowflake. One of the most irritating was what we at the office referred to as his Special Snowflakes. The teachers asked Snowflake's mom why they came. Let me quote Frank Slootman, our CEO: “Yeah, it’s one of those mindless things, right? I’m old enough to remember a world before they were Customer Success departments, and all of a sudden, everybody had them—they just did it, because well, Salesforce is doing it and so you know, we’re doing it too. 1. Aug 6, 2024 · Snowflake has an overall rating of 4. I worked in SQL server for the first 8-ish years of my data engineering journey (in addition to using other applications that connected to SQL server - SSIS, SSAS, Tableau, PowerBI, etc. Snowflake is interesting because the hype does match expectations. snowflake. Learning Snowflake is not enough. 76% of employees would recommend working at Snowflake to a friend and 79% have a positive outlook for the business. Personally, I really like that it delivers what it promises, but I don't like lack of customization and the fact their support/sales have a know-it-all attitude and they ask you to trust everything works automagically. 78 days when considering 345 user submitted interviews across all job titles. Due to its rapid growth in the industry, good candidates are required in the industry during recruitment. Hi people, Looking for guidance from professionals who are working at Snowflake. Snowflake is a data platform, which can include storage and compute. Ideally what Snowflake is creating will work more like SSDT in Visual Studio. Snowflake's mother was the icing on the cake. I don’t work for Snowflake or get any money from promoting them. Snowflake is used by multiple tech companies such as Amazon, Hubspot, Adobe, Square, Capital One and more. Micro-partitioning in Snowflake is a different beast, a good one, but not quite what I would call an advantage. Snowflake is made to handle billions of records efficiently. I know snowflakes IPO was a smashing success but I can’t imagine the company would be handing out equity to new employees like this. The CEO was a fairly nice, competent leader, but he had his quirks. As for being better at it, the main selling point of just about any X-as-a-service offering is that they take something that is complicated and expensive to do, centralize it and offer it at a potentially lower price/burden because they specialize. 568 votes, 65 comments. The smallest unit of storage in snowflake is a micro-partition, which contains up to 16MB of data. com/us/en/job/7261579002/Solutions-Architect-South-Central. WLB is poor in the cloud no matter where you work. I find it easiest for me to work through practical applications and learn progressively from questions that arise, while still working off foundational knowledge that I gained through the first hands-on badge. AWS Redshift doesn’t rlly have any edge over Snowflake. Since Snowflake partitions are closed-source, you can't operate them as individual independent files and handle them with 3rd party tools. Pretty bummed that one didn't work out, but happy to see the product Snowflake had so many "reasons" why she couldn't participate in the activities. If someone asks "How experienced you are with Snowflake", what is the better answer: "I have 1-2 YoE working with Snowflake. I keep unearthing fun and great youtubers who are sometimes sub 10k and are either about to blow up or are already out of the content creator job. See what employees say it's like to work at Snowflake. I have an SDR interview in 3 days with Snowflake and to be honest I am surprised they are even considering me. liii eadecr afkduzmd vekvti ppbiyds bkzk mpfb aiie rvu xyv