This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
The only problem with that "workaround" is that analysts who are usually using Alteryx can't (or at least shouldn't be allowed to) do that on an Enterprise Data Warehouse at a FTSE100 (or any other) company. The analsyt would require write permissons on a production data warehouse.
This only works in non production environments where you have write permissons on the tables, which I presume most people don't have.
For performance, an ETL process should always disable or drop indexes for inserts. That's what most of the big organisations using Informatica do and is recommended, production ETL accounts should have this ability.
That's correct, but the analysts who are the only ones using Alteryx do not and will not have the same permissons as the production ETL service accounts. For that we have Informatica as well. Analysts and with that Alteryx will have a read only access on the production DWH. The whole point of having Alteryx was to make the analysts' job easier, but with this limitation, it's close to being useless. Yes, there are workarounds, but for something so basic there shouldn't have to be workarounds, especially with a tool that markets itself as a tool that can make data easily accessible.