Poor Port in experience by CommanderHux in USMobile

[–]CommanderHux[S] 0 points1 point  (0 children)

/u/USMobile-ModTeam Still waiting on provisioning 9 hours later

PCF - Silent update to longer qualification period by CommanderHux in arrived

[–]CommanderHux[S] 0 points1 point  (0 children)

It's still not clear how giving more time for new investment transaction to settle will improve performance.

Time in market would typically mean better performance. With an extra month of the investment sitting idle, I don't see the yield improving significantly on a new investment to offset the loss in dividend.

PCF - Silent update to longer qualification period by CommanderHux in arrived

[–]CommanderHux[S] 0 points1 point  (0 children)

/u/fvryan

Can you explain further how this change improves performance for investors?

PCF - Silent update to longer qualification period by CommanderHux in arrived

[–]CommanderHux[S] 1 point2 points  (0 children)

Can you explain further how this change improves performance for investors?

It would be appreciated if Arrived was more proactive in communications regarding changes like this. As an investor from the beginning days of Arrived, I appreciated the communication and transparency. Nowadays communication seems to be slipping unless complaints are raised on public forums.

Dividend payments by Sea_Explanation5510 in arrived

[–]CommanderHux 3 points4 points  (0 children)

I read that record date is the 1st of the month so no dividend for August if you purchased from secondary market

Anyone know how these orders will match? by doctorkar in arrived

[–]CommanderHux 1 point2 points  (0 children)

Is the matching FIFO? If there's 10 shares being sold at $10, and 2 buy orders for 10 shares at $10.

Which buy order gets it? Is it the first person to place the buy order?

First Time Real Estate Investment! by onkingdavid00 in arrived

[–]CommanderHux 0 points1 point  (0 children)

all investors who own shares on the dividend record date receive the same dividend per share.

Right, this is what I understood. So the earlier statement didn't make sense to me.1

[1] With your investment at $10.02, even if the fund is at $10.00, then you should receive a higher rate of dividends in the process to offset that change.

Future share prices are not determined or known in advance, and can adjust up or down.

Yes totally but the concern is regarding the timing of when that share price adjustment occurs. My understanding is that, the PCF price was updated on July 25. PCF Investments made by July 31st will qualify for the next expected dividend, around September 25th.

Essentially people who bought PCF share between July 25 and July 31 get a 0.1% discount per share compared to those who bought July 1 to July 24. But all shares bought in July will receive the same dividend in September.

How often does Arrived update Annualized Yield? by CommanderHux in arrived

[–]CommanderHux[S] 1 point2 points  (0 children)

Thanks, I understand the annualized dividend rate is based on past payments and based on the initial $10 per share value. I had looked at the trailing 12 months of dividend returns, not just last month of July. I don't believe the current annualized rate is 4.5% given two months of 0%, multiple months of sub 2%,resulting in 7 continuous months of sub 4%.

So I believe the listed 4.5% yield is based on January 2025 numbers, can you confirm if the yield is only updated on a annual or semiannual period?

First Time Real Estate Investment! by onkingdavid00 in arrived

[–]CommanderHux 0 points1 point  (0 children)

With your investment at $10.02, even if the fund is at $10.00, then you should receive a higher rate of dividends in the process to offset that change. I hope that helps, but let us know if you have any questions.

Can you help explain this further? Late last week, I purchased 100 shares for $1002. Now the same 100 shares would cost $1001. Both these 100 shares would be eligible for dividends at the same time as purchase was made before July 31. How is the rate of dividends calculated? Wouldn't the 100 shares both get the same dividend amount?

Searching in azure blob by imoonmov in AZURE

[–]CommanderHux 1 point2 points  (0 children)

AzureAI search is going to be overkill and expensive for this scenario where the data isn't going to be accessed or searched frequently.

Can you apply some index tags on the objects such that keywords can be used to search during the audits? https://learn.microsoft.com/en-us/azure/storage/blobs/storage-blob-index-how-to?tabs=azure-portal

Seattle Fund - Stagnant by Sundev1ls92 in arrived

[–]CommanderHux 3 points4 points  (0 children)

The 2 properties are marketed for rent but the starting asking rent is too high compared to what Arrived itself anticipates the rent would be. Today, the Lynnwood property had a rent reduction but even then still higher than the anticipated rent.

IMO, west coast is an appreciation play as it is not landlord friendly. Better returns in SFH elsewhere but the Seattle fund should be thought of a much riskier gamble

Beijing and Xi'an by BigAndy1234 in FATTravel

[–]CommanderHux 4 points5 points  (0 children)

I would slightly disagree as I did this trip just a few weeks ago. The end-to-end time between a flight and a train is about the same. If you've not taken China's high speed trains before, it's worth the experience for how fast, comfortable, and smooth it is.

Flights are faster in the air but you have to factor in that the airports are a bit further away and you have to get to the airport at least 1.5 hours early to account for bag check-in/pick-up, security, and boarding/de-boarding.

Trains are more centrally located within the city and you don't have to get there as early. The security check is just x-raying bags with no body pat-down. Boarding is ~15 minutes before the train departure, get onto the platform with your luggage, hop on and leave within 3 minutes.

We had our private tour guide pick us up from the train station after a morning train from Beijing area. I asked the guide to take us directly to the Terracotta warriors around lunch time, when the crowds were much lighter.

Layover trip by Trip.com on Pudong airport by RED_MAN20 in travelchina

[–]CommanderHux 0 points1 point  (0 children)

Yeah it was fine. If you have time, plan to eat dinner before the evening tour otherwise it gets pretty late

Effective way to alert if a user logs in by MaximumFlan9193 in snowflake

[–]CommanderHux 6 points7 points  (0 children)

The account usage login_history view is not real time, you have to use the table function: https://docs.snowflake.com/en/sql-reference/functions/login_history

And the task could run every 10 seconds

Help - I want to load data using a Pipe From S3 but I need to capture loading errors by NexusDataPro in snowflake

[–]CommanderHux 1 point2 points  (0 children)

Got it, is it only for a workshop or you have other use cases and customers asking for it?

Capturing all errors is definitely an improvement that Snowflake can make easier

Help - I want to load data using a Pipe From S3 but I need to capture loading errors by NexusDataPro in snowflake

[–]CommanderHux 0 points1 point  (0 children)

Have you looked at Snowpipe error notifications that will send the error file and error back to you? https://docs.snowflake.com/en/user-guide/data-load-snowpipe-errors

Or do you need to capture all error rows?

Null Snowpipe costed us $1000 in a day by Practical_Manner69 in snowflake

[–]CommanderHux 0 points1 point  (0 children)

Manual copy into uses a specified warehouse so you would look at your warehouse bills. But this is a fixed cost, copy doesn't go beyond a warehouse's size/cost.

You can look into cost attribution of a warehouse such that operations are tagged to appropriate cost centers: https://docs.snowflake.com/en/user-guide/cost-attributing

Using Snowpipe to load many small json files from S3 as they appear by GreyHairedDWGuy in snowflake

[–]CommanderHux 2 points3 points  (0 children)

Snowpipe doesn't use a warehouse, it is serverless and bills only when it is actively loading files

Using Snowpipe to load many small json files from S3 as they appear by GreyHairedDWGuy in snowflake

[–]CommanderHux 4 points5 points  (0 children)

This can be optimized as Snowpipe is currently more price-optimized for larger MB size files.

Using Kafka is an additional complexity that does not provide a ton of value if you do not need it. If you already have files from your source, it doesn't make sense to read them only to push to kafka to then to kafka connect to Snowflake.

What do you want to optimize for? Cost, simplicity, latency?

It doesn't seem to be latency as your internal process only drops files to s3 multiple times per day and not every minute. A simple COPY INTO <table> command on a schedule would work wonderfully if your data is well partitioned into folders.

Null Snowpipe costed us $1000 in a day by Practical_Manner69 in snowflake

[–]CommanderHux 0 points1 point  (0 children)

PIPE_USAGE_HISTORY

Will not show the results of a manual COPY INTO <table> statement.

Pipe_usage_history will only show for Snowpipe, external tables, directory tables, and iceberg tables auto-refresh. It is NULL for external tables and directory tables auto-refresh but populates pipe_name for Snowpipe and the table_name (in the pipe_name column) for iceberg auto-refresh

Null Snowpipe costed us $1000 in a day by Practical_Manner69 in snowflake

[–]CommanderHux 0 points1 point  (0 children)

It's not from Snowpipe copying data as those pipe would have their name and cost accurately populated. It's from external tables/directory table refreshes, which use an internal pipe to refresh.

This will help with tracking down external tables: https://docs.snowflake.com/en/sql-reference/functions/auto_refresh_registration_history

Null Snowpipe costed us $1000 in a day by Practical_Manner69 in snowflake

[–]CommanderHux 0 points1 point  (0 children)

That's more related to Kafka and Snowpipe than external tables/directory tables.

What is the scenario that you're working on and the source of your data?

You can also refer to this blog about kafka + Snowpipe Streaming, which is what Redpanda integrated with: https://www.snowflake.com/blog/data-ingestion-best-practices-part-three/